Show some or all

[protean_being]

I have a True/False field in a table called Remakes.


I have a form that has a combobox called cbo_Remakes.
The combo box has the values "All", "True", "False"
The form has a button that activates a query (for a report).
Basically what I want is to filter by True or False (which works, I'm using the switch statement) or select "All" to not filter.
How do I tell the criteria to select all records?

[narayanis]

try this for the criteria for ALL:

SELECT *
FROM table where truefalsefield is not null

does that help?