Check Box query help

[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

 

[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!

 

[KARL DEWEY]

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) +

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.