Open record on form with list box selection.

[Guest]

I have a list box on a form "Customer By Date", which is based on a query.
The customers name, orderID, order date, and phone number are in the list
(four columns). The query pulls up the list in a date range. I would like to
click on a record and have it open the customers order on the "Orders
Form"(The "Order Form" has these fields in it). All I can get it to do is
open the "Orders Form" to the first record in that form I am new at this (if
you can't tell). Anyone who can help get me started in the right direction
would be appreciated.

 

[Guest]

Try this link, it provide an example for a similar question

http://www.databasedev.co.uk/list_box_searching.html

 

[Guest]

Thanks. I Will try this and get back.

Try this link, it provide an example for a similar question

http://www.databasedev.co.uk/list_box_searching.html