Filters in subforms

  • Thread starter Thread starter K. Weiss
  • Start date Start date
K

K. Weiss

I have a form with various subforms in it in Access 2003.
I have macros to apply filters to the main form, and use
Filter by Selection to filter records in the subforms as
needed by the specific task. However, the filters in the
subform are saved automatically when I close the form, so
I'm constantly having to clear existing filters to use
the filters that I need.

Is there a way to prevent the filters from being saved
with the subform, but still allow filters to be applied?

KW
 
Use the UnLoad() event of your main form to clear the
Filter properties of your subforms.

eg)
Me!SubformControlName1.Form.Filter = ""
Me!SubformControlName2.Form.Filter = ""
etc...
 
Back
Top