Combo Boxes containing the value "All Values"

[Guest]

I have a few combo boxes that are dependent on each other. I use code that
sets the record source for each combo box to a different query. The problem
is if the user selects a value, and requeries the combo box, I lose the value
"All Values". I do not have "All Values" as a value in the table that each
combo box queries from since I would have to create numerous combinations.
My logic in each query states if the user selects "All Values" return all of
the values in the table.

How can I keep all of the values that are queried from the table in the
combo box, plus the value "All Values"? Is there a way to set the record
source to a query plus a value such as the default value?

 

[Wayne Morgan]

Base the Row Source on a query that is filtered by the value in the
preceding combo box. UNION this query with one that has the "All Values"
option.

Example:
http://www.mvps.org/access/forms/frm0043.htm