Return all values from Combo box form

[jake.friedman]

Hi.

I'm trying to use forms to allow a user to select multiple parameters
to execute a query on the "front end". For this example let's say we
are querying, choosing options from three different combo boxes that
link to a query. I want to be able to choose from two of the combo box
lists, but then query everything on the list from the third combo box.
How would I do this? (i.e. limit the search in two combo boxes but
search for all in the third).

Thanks.

 

[Duane Hookom]

Have you considered using a multi-select list box? Depending on how you are
applying the filter and how the query is displayed you might be able to add
"All" to the Row Source.