Overfør værdi fra formular til formular

you could try this

    DoCmd.OpenForm "YourFormNameGoesHere", , , , acFormAdd
    Forms!YourFormNameGoesHere.TheFieldNameGoesHere = SomeValue

im trying to do what your suggesting, but this line appaenrently has bad syntax: Forms!Betaling opret ny.ID = DoCmd.FindRecord Me!ID
Is it the spacing in the form name?

Ok just figured it out. The spacing was a problem but can be remedied by surrounding the form name with square brackets, for example:

Forms![Betaling opret ny].ID = DoCmd.FindRecord Me!ID

Nope doesn't work after all. The Forms![Betaling opret ny].ID part works but I cant seem to transer the ID from the previous form at least not woth the code im using (DoCmd.FindRecord Me!ID). Anyone any suggestions?

Du kna benytte flg. kode, der her er vist med et alfanumerisk felt, et numerisk og et datofelt. Koden kraver en reference til DAO i VBA-editoren Tools References > Brows ned igennem bibliotekerne og fin Microsoft DAO 3,xx Library. references kan hedde lidt forskelligt afhængig af din programversion, men blot der står DAO er det OK. Sæt er checklmærke i den lille boks i venstre side:

Private Sub Form_Current()
Dim rs As DAO.Recordset
If Me.NewRecord Then
Set rs = Me.RecordsetClone
rs.MoveLast
Me!felt1.DefaultValue = "'" & rs!felt1 & "'"
Me!dato.DefaultValue = "#" & rs!dato & "#"
Me!talfelt.DefaultValue = "" & rs!talfelt & ""
rs.Close
End If
End Sub

Sorry Elizabeth, didnt see you had problems here!

FindRecord means that you are trying to find a record on a form, but that c ant be the case when you are creating one "...jeg sidder med en "opret ny post" formular"