Filters in subforms

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
 
E

Elwin

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...
 

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

Top