Returning all values in parameter query?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a parameter query that looks at a combo box for a list of values in
Access 2000. I want the query to return all the records if "All" is selected
in the combo box. Is this possible?
 
I have a parameter query that looks at a combo box for a list of values in
Access 2000. I want the query to return all the records if "All" is selected
in the combo box. Is this possible?
Click to expand...

Use a criterion of

=[Forms]![YourForm]![YourCombo] OR [Forms]![YourForm]![YourCombo] =
"All"


John W. Vinson[MVP]
 
Thanks - that did it!!

John Vinson said:
I have a parameter query that looks at a combo box for a list of values in
Access 2000. I want the query to return all the records if "All" is selected
in the combo box. Is this possible?
Click to expand...

Use a criterion of

=[Forms]![YourForm]![YourCombo] OR [Forms]![YourForm]![YourCombo] =
"All"


John W. Vinson[MVP]
Click to expand...
 
Back
Top