Find a record in the listbox

[sabavno]

Hi,

I have populated a listbox based on the query. Now I want to include a button "FIND" to find a record (row in the listbox) that includes a field(column) value that the user inputs in the input box.

PLEASE....advise on this issue

Thanks

 

[thornmastr]

Don’t make it so difficult.

You don’t need a find button. You can use the after update event of your combo box. Just make sure that if the field displayed in the combo box cannot directly be used to look up the corresponding row in your other table(s) that you include a hidden column in your combo box which includes the foreign key to your other table. In fact, you can make the lower part of your main form into a child form container, and relate the combo box to the sub forms as a child field. Then, whenever the user picks a value from the combo box, Access will automatically load your child form with the linked record.
Robert Berman
Data Base consultant
Vulcan Software Services
thornmastr@yahoo.com