How do I link a command button to querying a list box?

J

JCislo

I pulling a SQL data base of customers into a list box on a form. I would
like for my user to be able to click a command button (i.e. Search) and be
able to have the user enter a search string in a box to search for a specific
customer. I would like for the results to appear in the list box and for
them to be able to select which customer they want to create a new record
for. I know how to run the query but when I link it to a button it just
returns the results back in a table form. How do I get those results to
appear in my list box and requery them as many times as I want and when I
move to the next record?
 
Top