Apply Filter to a Form
Hello all!
I have an unbound main form in an Access Data Project that has three forms used as mutually exclusive source objects of the main form. They are opened by selected their name from a combo box in the toolbar.
I have three "flavors" of each form and that is because a different set of data is pulled based on the user's security level.
Now, my users would like to be able to use the Filter by Form feature to filter rows out of the data set. Is this possible or are these forms treated as subforms?? I've read in several postings that filtering can't be done on subforms and now I'm wondering if I'm screwed.
I got it to work a while back before I made the different "flavors" of the forms and everyone had one level of access. However, that was by programmatically setting a filter using the Filter and FilterOn properties.
Your help is appreciated!
atrapp
Hello all!
I have an unbound main form in an Access Data Project that has three forms used as mutually exclusive source objects of the main form. They are opened by selected their name from a combo box in the toolbar.
I have three "flavors" of each form and that is because a different set of data is pulled based on the user's security level.
Now, my users would like to be able to use the Filter by Form feature to filter rows out of the data set. Is this possible or are these forms treated as subforms?? I've read in several postings that filtering can't be done on subforms and now I'm wondering if I'm screwed.
I got it to work a while back before I made the different "flavors" of the forms and everyone had one level of access. However, that was by programmatically setting a filter using the Filter and FilterOn properties.
Your help is appreciated!
atrapp
Last edited:
