Filtering a report from multiple checkboxes

[sabre1]

I have a check box on a report which i would like a user to be able to tick the box and for that to then filter on a specific field on the report. This wokrs by having an OnCLick command on the checkbox however, is it possible for the user to check 2 boxes at the same time and for the On Click filter to include both? For some reason it keeps flicking from one to the other instead of including both.

Would greatly appreciate your help and if you need any more information please do not hesitate to ask.

Thanks.
Kelly

[kbremner]

I'm having a similar dillema. However, I have been able to do what the OP is asking. My problem is I want to use a large number of checkboxes and in "groups" to filter the results. There will be a number of different groups of criteria.

For example I would have checkboxes for "Commercial" and "Residential" and boxes for "Income Level 1", "Income Level 2" and "Income Level 3" and probably more. By default, all of these boxes would be checked and all of the records would be displayed on the (sub)form. I want a user to be able to (either on the fly, or make all the changes and then press a command button) uncheck boxes and have the appropriate data displayed. I originally had just one set of checkboxes - commercial and residential. In the After_Update event for each checkbox, I basically checked the other. In other words, you uncheck Commercial, Access would check to see if residential was checked and then show records based on that. That method will get very cumbersome as I add new options. Is there an easier way? Please point me in the right direction, as to where I might be able to get some insight into this type of thing.

[ajetrumpet]

start a new thread please