parameter query

  • Thread starter Thread starter brian
  • Start date Start date
B

brian

Hi,

I want to build a parameter query where 2 parameters are
selected from two comboboxes on a form.

My problem is I also want to have a "select all" criteria
in one of the comboboxes. I can do that by a union query.
However when the criteria is "select all" in the first
combobox the query does not filter the second criteria in
the second combobox and shows all the records.

When first combo value is "select all" i attain a certain
value to that combobox like 100000 where the combo value
is numeric. And my query criteria is like:

Field : Company_ID
Table : Companies

Criteria : [Forms]![Form1]![Combo1]
or [Forms]![Form1]![Combo1]=100000

This technique works where it is the only criteria, but
when i add a second criteria it neglects the second.

Thanks for help.
 
Actually i found the answer while trying. I also added
the second combox's criteria to the second line (it
should be both in the first and the second line) and the
problem is solved.
 
Back
Top