Criteria for query from selections out of mutiple listbox 1

[DriesG]

Hello,

I have a query that I want to filter with a criteria in a certain column. When I tell the qeury to get the criteria from a listbox in a form, that's no problem, as long as the listbox is not set to multiselect.
If I change the listbox to multiselect, the output of the box is always 0. I know that's normal. The query won't work.
You can retrieve the information of the bound column from the listbox with the function itemsselected.
If you select an item in the listbox, this function gives you then the value of the bound column from the item you have selected. With this information, the query works.
Only, if I make multiple selections, I only receive the information of the highest value from all the items I have selected in the listbox.

Is there any way you can tell a query that it has the filter the items you have selected in a multiple listbox?
For example: criteria = listboxitem1 or listboxitem2 or ...

Many thanks for any suggestion.

Best regards,
Dries

 

[dhookom]

Roger Carlson has a web site

http://www.rogersaccesslibrary.com

with lots of small sample databases. There is one that answers your question:

http://www.rogersaccesslibrary.com/download2k.asp?SampleName='CreateMultiSelectQuery2k.mdb'

Duane
MS Access MVP