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

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

PC Datasheet

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

Richard.K

Joined
Jul 5, 2011
Messages
1
Reaction score
0
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Criteria to return all records if selection from form is null 3
no criteria 3
IIf statement in query criteria 5
Null Criteria Problem 4
Criteria for Query IIF clause 9
Query Criteria Not Working 2
Parameter Query based on Form 2
parameter with iif statement in query criteria 8

Top