Link fra formular til formular

Use the button wizard to help you make the code. Then in the on double click of the listbox you can use the code you made withthe wizard

When you us ethe button wizard you should end up with some code like this

Private Sub Command6_Click()
On Error GoTo Err_Command6_Click

    Dim stDocName As String
    Dim stLinkCriteria As String

    stDocName = "Form1"
    'You now need to initialize the stLinkCriteruia. This is similar to the WHERE in an SQL statement.
    'In the example I am assuming that your listbox only contains one field which is text.
    stLinkCriteria = "SomeField = '" & Me.YourListbox & "'"

    DoCmd.OpenForm stDocName, , , stLinkCriteria

Exit_Command6_Click:
    Exit Sub

Err_Command6_Click:
    MsgBox Err.Description
    Resume Exit_Command6_Click
   
End Sub


Now in the on double click event of your listbox you could  use Command6_Click to open your form.

Thanks again Terry, used the button wizard - works perfectly...

:o)