K
kbremner
I want to be able to filter my records based on a series of checkbox
selection. 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.
selection. 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.