Stored Query - Criteria if box = true, => true, if box = false =>

  • Thread starter Thread starter BlueWolverine
  • Start date Start date
B

BlueWolverine

Hello,
MS Access 2003 on XP Pro.

I have a search panel i built and I want to all the user to either specify
"Search by other" or Don't. The data gets pulled out of a stored query.

What I mean is that my data has a True/False field called "Other" I want a
control the user can toggle between true and false to indicate "YES, limit
search to only those where Other = True" or "No, return all results
regardless of Other." I wouldn't necessarily mind being able to search for
the third state, "Yes limit my search to only those where Other = False" but
I don't necessarily need it.

Ideas?
 
A check box would work. Assuming the check box is named chkOther and it
being checked means limit to only those rows where Other is true, you would
then add criteria in your query for the field Other:

Like IIF(Forms!MyForm!chkOther = True, True, *)
 

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

If calculation in text box > 1 hour set check box = True 2
True/False calculation converted to checkbox? 3
True, False, or Both criteria 4
Selection makes text box visible/hidden 3
AllowEdits False and a combo box 2
Combo Boxes - DISPLAYING multiple fields after choice is made 5
DataEntry = False, after form is open ???? 2
Error: Compile Error,ByRef argument type mismatch 0

Back
Top