Removing subform filter without removing mainform filter

B

BeenPuzzled44

I want to filter to different values on my subform and remove the filter
without removing the filter applied to the main form. Is this possible and
how?
 
A

Allen Browne

You can turn the filter off for a specific form by setting its FilterOn
property, e.g.:
Forms!MyMainForm.FilterOn = False
or
Forms!MyMainForm.MySubform.Form.FilterOn = False

HOWEVER, if you apply a filter to the main form and also to the subform,
Access gets confused when you try to remove the filter. This bug is issue #1
in this article:
Incorrect filtering
at:
http://allenbrowne.com/bug-02.html

The bugs discussed in that article apply to Access 95, 97, 2000, 2002 and
2003, but they are fixed in Access 2007.
 
Top