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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top