Returning all values in parameter query?

A

argear

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?
 
J

John Vinson

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]
 
A

argear

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...
 
Top