subform filters on tabbed form

[gtech08]

I have a tabbed form with a subform in each tab. Each subform has a filter that needs to be on all the time. So for the 'On Open' property of each subform, I have 'Me.FilterOn = True'.

The problem is that when I open my tabbed form, only the first subform filter is applied. The other subforms show all records, and there is no '(Filtered)' next to the navigation buttons. I also tried turning on the filters from the main form:

Me.[Subform1].Form.FilterOn = True
Me.[Subform2].Form.FilterOn = True
...

Again, only the first subform filter is applied. If I reverse those two statements, only the second filter is be applied. Is there any way I can apply more than one filter or is there some kind of limitation? Any help is greatly appreciated. Thanks.

 

[PierreR]

Sounds like every subform has the same form as Source Object (a property of the subform), which can have only one filter at a time. Try making several different queries, all based on the same main query, and do all the sorting and filtering you want. Instead of using a tab control you can make a row of buttons in the form's header, each button changing the Record Source Property between the different queries.