Multiple field query

[Chellie P]

I'm fairly new at using Access. I've got myself stuck on something that I
think should be fairly easy. Here goes my example . . . a form containing
several list boxes--one box has Grocery Store A, Grocery Store B, Grocery
Store C. Another has apples, oranges, milk, bread, etc. I would like to
choose Grocery Store B as well as apples and oranges and have those records
open on click of a command button. I'm struggling finding the best way to do
this.
--

 

[Duane Hookom]

What do you mean by "have those records open on click of a command button"?
Do you have a form or report you are attempting to open?

 

[Chellie P]

Well, I'd like to run a query based on the items being selected.

 

[Duane Hookom]

I have a generic function for use with multi-select list boxes in queries at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.

 

[Chellie P]

Thank you!!!!
--
Chellie

I have a generic function for use with multi-select list boxes in queries at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.