Using List Box Selections As Query Criteria

K

Kevin Sprinkel

I'd like to use multiple selections from a list box as
query criteria, connected by a logical OR.

I guess I need to loop through all selections, adding them
to an SQL string, but don't know how to do this. Can
anyone help?
 
P

Pat Hartman

Look up this knowledgebase article.

135546 - How to Use a Multi-Select List Box to Filter a
Form
 

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

Trying to create a report that will list unmatched records by Ticket Primary Key 0
How to Change criteria on a saved query using VBA 0
Drop down list control value in vba 2
List box 2
Using combo box selection to supply criteria for query 25
list or combo box 0
'Data Type Mismatch In Criteria Expression' error when using 'Count' in query Design; Help! 0
Do not run subform criteria when form opens 2

Top