Switching the select criteria between a Form field and ALL

J

Joseph

I like to set up a query with the ability to select on data in different
data fields.
I made a form for potential criteria fields, each with a True/Flase check
mark besides it.
The problem is that I can not get the criteria to default to ALL, as is
with Like "*"

The formula
IIf([Forms]![PrintRequest F]![Emp_IDcheck]=True,[Forms]![PrintRequest
F]![Emp_ID],Like "*")
works fine for the True state, but not for the False state.

Is there a way to get it to switch to all?

Thank you
Joseph Rudigier
(e-mail address removed)
Remove the SSS in the address, added to reduce spam
 

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

How do I clear a form? 0
Criteria to return all records if selection from form is null 4
IIf statement in query criteria 3
Criteria to Select Field to Update 4
Problem with Query Criteria by IIF/Switch 1
How To Specify No Criteria 2
Selection Criteria 1
Entering criteria from form 2

Top