Multiple criteria in a query?

[NewShoes]

Hey all,

Really hope someone can help on this!

I have a database with cars listed, each car having its specific details. What I would like is a way to select on a menu form multiple cars and then to click a button to run a query on the cars selected (which would return the cars details). I can do this with just one car by using a combo box but I'm unable to see a way of selecting multiple cars.

I cant use tick boxes as cars will be added weekly.

Hope this makes sense,

Many thanks,
-NS

 

[pbaldy]

I often use this technique to filter a form or report on a multiselect listbox:

http://www.baldyweb.com/multiselect.htm

 

[NewShoes]

Thanks for that pBaldy. Do you have a technique if I don't want the results to be in a report bu rather just in a table?

-NS

 

[pbaldy]

Like this?

http://www.baldyweb.com/MultiselectAppend.htm

 

[NewShoes]

Sorry Paul, I didn't mean the results to be PUT in a table but rather to just be displayed (similar to when you run a basic query, the result is just displayed in a table view).

thanks,
-ns

 

[pbaldy]

I never allow users to be directly in a table or query, so not sure offhand. You can't just refer to a textbox that has multiple items in it.

 

[NewShoes]

OK, thanks for your help