Formular - med tilknyttet

Th eeasiest way is to add a button on the form using the wizard. This will make the code needed to open th eother form. You can also ask it to open the form with a specific record.

Now you have the code.

In the fields on double click event (or on click even) copy and modify the code from the buttons on click event. Then once its in place remove the button.

Another way is to just add the following to the on double click event

    Dim stDocName As String
    Dim stLinkCriteria As String

    stDocName = \"FormToOpen\"
   
    DoCmd.OpenForm stDocName, , , stLinkCriteria, , , Me.Nummer

And in the On Load event of the form which you open add the following

    If Not IsNull(Me.OpenArgs) Then
        \' Find record
        Me.RecordsetClone.FindFirst \"[Nummer] = \" & Me.OpenArgs
        Me.Bookmark = Me.RecordsetClone.Bookmark
   
    End If

You obviously need to alter Nummer to the correct field name

tak :o)