MS Access 2003: Toggle Multiple fields with checkboxes/toggle buttons 1

[WhiteRogue]

Hi Everyone.

I'm building an inventory database for personal use. What I'm having trouble with (to be honest i dont really know where to start.) is making a form with some buttons on it that filter out things from my massive inventory list. Heres some details:

The table consists of:
ItemName: Exactly what you'd think; an item with a name.
YES/NO_1: A yes/no, default no,
YES/NO_2: etc.
YES/NO_3: etc.
(There are more fields, but they don't come into it)

Each entry in the database can be any combination of either or all, or even none of the YES/NOs ... I'm really hoping i don't have to do LOADS of queries to cope with EVERY combination...

What I want to do is have a form with some check boxes/toggle buttons up the top and something like a datasheet down the bottom. When you toggle a box/button on the form it changes the filter to match, while not affecting the filter for the others.

I have some other issues, but this is the biggest and i might be able to figure out the other ones if i can get some help with this one.

 

[WhiteRogue]

Oh, one more thing.

If any of the YES/NOs are True (yes...) then i'd like the result to still show up. eg.

Y/N1: filter says hide.
Y/N2: filter says hide.
Y/N3: filter says show.

So anything with a positive in the Y/N3 would show up, even if it had 1 or 2...

 

[PHV]

Have a look here;

http://r937.com/relational.html

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886