Query base on list box

A

Alex

I would like to develop a query (qry_selected_dealers) base on list box
(lstdlr). The user will be able to select multiple dealers from the list
box. The query should exclude whatever has been selected. However, if
nothing is selected then all data should be shown. My listbox pulls the list
of dealers off a table (tbl_dealers). I am not good in coding, and would
like the query be able to run base on the criteria of the list. Any help
would be appreciated.

-Mario
 
A

Alex

I've tried using that code and replacing certain fields with my own. There
are a few errors, particularly the last coding. It highlightes red. This
will also show all dealers if nothing is selecteD?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top