Subform filter on open

RasterImage

New member
Local time
Today, 12:52
Joined
Nov 4, 2010
Messages
6
If I apply a filter to a subform, then close the parent form and reopen, the filter has dissapeared. This doesn't happen with regular forms.
Please: how can I make the subform open with filter applied by default, but still be able to take filter off when desired?
Thank you.
 
No worries.
Figured out how to make a macro filter the subform, and set it to run on load for the parent form.
Please ignore me.
 
pls tell me - how to make a macro filter the subform!!!
 
Say your subform is based on a table:
Make a query which is like the table, but with a criterion.
Make a macro with 1 Action - ApplyFilter, with Filter Name the name of your query, and Control Name the name of your subform.
Set the macro to run when the parent form loads.
 

Users who are viewing this thread

Back
Top Bottom