Multiple selection list box

C

Chris

My hat goes off to you if you can help.

I created a form for users to make selections that will
query the database and have written a procedure to execute
the query. I want to give the user the option to make
multiple selections in the list box, I have set the list
box Multi-Select property to Simple and need to know how
to write the code for the 'WHERE' to recognize the
disctinct choices made by the user. (Each listbox will
offer hundreds of choices that will change, using an If
Then is not an effective option for me.

In advance...thanks!
Chris
 

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

limiting list box selections 1
conditional list box 6
Create a multi-select list box with a NotinLIst procedure 1
Copying List box values/selection to a database of sorts 2
Multi-Select 0
Multi Select List Box in Access 0
Run select query from VBA code where criteria comes from a multi select ListBox 2
Filter records in a subform based on list box selection 5

Top