Filtering forms with check boxes

[Brad108]

Hi

I have a form with 10 check boxes. All put a value into different fields as they relate to different criteria.

I need to filter via numerous combinations of check boxes (i.e. to find out which contacts have had a certain letters sent etc) and setting up reports for each one would not be right as there as so many different combinations.

What I would like to do is have a screen where I can select a variety of check boxes and access then filters this information to show which records match this criteria.

I've spent ages trying to get this to work and have got nowwhere.

Can anybody suggest the best way to do this?

Thanks so much for your help - its really appreciated.

Kind Regards

Brad

 

[Brad108]

Just to clarify, I have tried using a normal 'filter by form' but when I select check boxes for 'letter a' and 'letter c', it comes back with all companies with which 'include' those 2 checked, not just those companies with ONLY those 2 checked.

This is just an example, but I hope someone understands and helps me out with this.

Really appreciate it...

Thanks

 

[CEH]

I had this set up for filtering by dropdowns... But I added a checkbox and it also works.. See if this gives you what your looking for.