HELP! List Box

N

NDClark

I put a List Box on a form. I want to be able to Double click the data in
the List Box and open another form to edit it.
 
B

Beetle

Well, you haven't given us much info to go on, so assuming the list box
and the form have some field in common (i.e. CustomerID), then the code
for the Double Click event of the list box might look like;

Private Sub lstYourListBox_DblClick()

DoCmd.OpenForm "frmYourForm",,,"CustomerID=" & Me.lstYourListBox

End Sub
 
Top