finding a record in a listbox using a command button

[OOO]

Hi
I am creating a db where I am to make a switch board that contians a listbox with course# and coursename as the fields in the listbox, and by clicking the record in the listbox, then using a command button to find the record, would it come from the query or the table and more importantly how do I make the command button and listbox work together like above????????

Thank you very much in advance!!!!!!!

 

[DougP]

It will work just like you want it to.

the command button needs to to pass a new recordsource to the form
like so:

Me!recordsource = "Select * From yourTable Where somefield = '" me!List1.text & "'" DougP, MCP

Visit my WEB site

http://www.barcodeone.com

to see how Bar-codes can help you be more productive

 

[OOO]

I dont really understand could u try again plzzzz