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

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

Guest

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.
 
Put the following expression in the criteria:
Forms!MyForm!NameOfDropDownBox Or (Forms!MyForm!NameOfDropDownBox Is Null)
 
Hi I tried your criteria method of FormS!MyForm!DropBox or (FormS!MyForm!DropBox Is Null) and it works the first time then it creates multiple instances of the criteria to the point that the query will no longer work??

Any solution to this problem?

THanks
Richard.K
nb: I am not the original poster of the message
 
Back
Top