Using a combo box to make multiple selections that are used in a report's query

[JEG64]

Hi,
I would like to use a combo box based on 6 different choices where a user can select more than one choice and have the different choices selected be used in a report's query. For example:

I would like a report that lists the users with red and/or blonde hair. The combo box would be based on this value list: red, blonde, brown, black, gray, white. The report's query would say where field haircolor=the value(s) of the combo box.

I'm using Access 2010 and I read about multivalued fields and check box drop down lists. I figured out how to add a multivalued field to a table, but I don't really need to save the multivalues in a table, I just need to use them in a query.......I'm a bit confused....

Thanks in advance!

 

[MajP]

Faq701-6099

 

[JEG64]

Thanks very much! I'll give that a try tomorrow....