How do I set a criteria in Access to show all if null or the cont.

V

VHII

I am trying to make an IIF statement in a query that looks at the form and if
it is null show me all records, or show only the ones the I selected with the
drop down box in the form.
 
P

PC Datasheet

Put the following expression in the criteria:
Forms!MyForm!NameOfDropDownBox Or (Forms!MyForm!NameOfDropDownBox Is Null)
 
Top