Filtering records by means of Option Button

[McArthurGDM]

I have an option button. I want to give the user the ability to click the button and to filter out certain reports if they do. In particular, I have "Yes/No" boxes set up. If they click the button, I want them to filter out the ones that are indeed clicked. Also, if they don't click anything, I want nothing to happen.

How do I set this up in my query?

Thanks

[June7]

You have multiple yes/no boxes? Are these bound to fields? If yes, I suspect non-normalized data structure. Probably will need VBA.

[McArthurGDM]

Correct. My database is indeed non-normalized... due in part to using multi-value fields. Of which, I have managed to do some impressive things. I just hope this is the last time I have to use multi-value fields...

I will probably need VBA, yes.

[June7]

Actually, I am not even sure VBA can help. Trying to apply criteria to multiple yes/no fields for similar data (when there should really be a related table with a record for each field) is very frustrating. I usually give up.