Query Criteria Help

[Djbell]

Hi All

I have a form with two combo boxes that I use to change the criteria for the query, everything works great, what I want to do is change these Combo boxes to multiple select list boxes so the user can choose more than one item for the query. So I changed both to List boxes and tested everything works great, but the minute I change Multi Select from none to simple or extended, the query returns no results. To test the query I put one item entry in Criteria and one in or, and the query gives the results expected, change it back to the list box and select the same two items and the query does not display any results..

How do I use a multiple select box in the criteria for a query so that it picks up on all items selected.

Anyone help me out?

Regards

Djbell

 

[PaulBricker]

This faq should help.

faq701-4696


Paul

 

[dhookom]

There is a generic multi-select list box function with sample usage at

http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]