Double Click Listbox matching records question

[Draedric]

I have a search page that returns restults into a listbox which I want to be
able to double click and have it open a form that displays that record... I
put a macro in for it that opens the form and all just fine but I am having
trouble making the records match.. like if it is customer1 in the listbox i
need it to display customer1 when I double click it right now it is going the
front of the records. I need to mention the form it opens on double click the
actual data is in a subform so the form it opens is customers with a subform
customersub which displays the record information.. anyone help me with this
macro or suggest a better way to make it work?

 

[Jeff Boyce]

Another approach would be to add code to the Double-Click event for that
listbox. The code would include the command (and syntax) for opening the
form -- you'd be able to use the filter/where clause of the syntax to "set"
the record id from what was selected in your listbox. The command looks
something like:

DoCmd.OpenForm "YourFormName",,,...