Removing subform filter without removing mainform filter

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Subform filter is inherited? 3
How do i search a subform from the Mainform? 6
If else subform reference access 2007 2
Filtering subforms via main form 2
Report based on a filtered form 2
Selecting current record in subform after removing filter 1
Filtering Subform 10
ApplyFilter event on a subform 1

Back
Top