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!

"Steph" wrote:

> 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

>>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 with my checkboxes in it,
An Option Group uses a single field to store the data and only one of its
boxes can be checked at a time.


--
Build a little, test a little.


"Steph" wrote:

> 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!
>
> "Steph" wrote:
>
> > 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