need help using IIf condition in a query

S

scaramanga

Hiya,

I'm trying filter my query using the criteria row in the query's desig
view. But I want the filter only to be applied under certain condition
- a check box being ticked on a form. I've got as far as using an II
statement in the criteria box of the field i want to filter, m
expression currently looks like this:

IIf([Forms]![Filter Form]![CheckFilters]=True, "PoD" , ????)

So if the checkbox is ticked, the query filters out all records excep
for PoD records, which is great. But if the checkbox isnt ticked,
dont want any filter to be applied - however I dont know what to put a
the third argument to make this work.

Please help
 
Top