Check Box query help

  • Thread starter Thread starter Steph
  • Start date Start date
S

Steph

Morning all, looking for some more help from my gurus.

What I have:

A table with 4 or 5 text fields, and 8 Check Boxes.

What I want: A query that will allow me to Query a couple of those check
boxes that will return both.

IE: one box - Simple
Two checked, - return records with BOTH check boxes selected.

As always, thanks in advance.

Steph
 
While i am being greedy, what would be my ideal situation is to have say, an
Option Group with my checkboxes in it, and when checkboxes are selected, my
form (or subform) is automatically filtered without leaving the form.

Is this possible?

Thanks again!
 
What I want: A query that will allow me to Query a couple of those check
boxes that will return both.
So why not put an unbound checkbox for each in the form header to use as
criteria?
My_Calculated_Field: IIF([Forms]![YourForm]![Cbo1] =-1 AND Table1.Cbo1 =-1,
1, 0) + IIF([Forms]![YourForm]![Cbo2] =-1 AND Table1.Cbo2 =-1, 1, 0) + ...

Criteria --
= IIF([Forms]![YourForm]![Cbo1] =-1, 1, 0) +
Click to expand...
IIF([Forms]![YourForm]![Cbo2] =-1, 1, 0) + ...
An Option Group uses a single field to store the data and only one of its
boxes can be checked at a time.
 
Back
Top