I have used vba code to open a (unbound) form that has a subform bound to a query.
I want to apply a filter to the subform. I can do it after the main form is opened, but then get many unwanted records before the filter is applied.
How can I set the subform filter before the subform accesses any records?
I want to apply a filter to the subform. I can do it after the main form is opened, but then get many unwanted records before the filter is applied.
How can I set the subform filter before the subform accesses any records?