Filters based on selection

[gajh]

Hi I have a form with 5 check boxes on I would like to be able to select any number of the check boxes and then have it apply as a filter to a query to show all the records that meet any of the check boxes that are ticked.

Hope you can help

 

[M8KWR]

I have done something like this before, what i had to do is everytime a checkbox is checked or not, run some code on that to update a textbox, that is not visible to the user.

Once you have a value in the textbox then you are able to run filter on those values, and not the checkboxes.

This is the way i would do it, but not saying its the best. I know it works.

I you want any help in structuring in, or writing the code and where it goes let me know