Combo Box Value that acts like multiple values

[uztwilightzone]

Hi there,

I have a combo box [Combo30] on a form that triggers an event
OnChange.

The drop down lists different Party Rooms that we have at our
facility. When one of the Rooms is selected, it runs a report based on
a query that lists all upcoming parties in the room that is selected.

In the query, the Party Room we selected is called:
[Forms]![Party Transaction Selector]![Combo30]

The Party Room names are stored as a value list. My question is, can
we create a value that selects two rooms? That is, rather than running
the report for "Red" and then "Blue", can we make one "Red&Blue" that
will list all upcoming parties in both rooms, rather than running the
report twice with the separate rooms?

Thanks for any help you can give!

 

[Douglas J. Steele]

Not with a combo box you can't.

However, list boxes have a Multiselect property that could be set to allow
the users to select more than one value. You'd then have to dynamically
alter the SQL of the recordsource for the report.
http://www.mvps.org/access/forms/frm0007.htm at "The Access Web" gives an
example of what's required.