I would like to see all records returned on a query using Access 2010

I have a query that looks for a value on a form "IFLOC"
and depending on the value present it returns records associated to the value.
The problem I have is if I don't specfy a value then no records are retrieved. What can be added below so that if no value is present in field "IFLOC" then all records are returned as a result.

[Forms]![Master Form]![IFLOC]

Thanks!
_HectorAsked:
Who is Participating?
 
peter57rConnect With a Mentor Commented:
In the criteria cell...

[Forms]![Master Form]![IFLOC] or ([Forms]![Master Form]![IFLOC] is null)
0
 
_HectorAuthor Commented:
Thank You !
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.