I have created a form that contains 2 sub forms based on 2 different tables. The problem is trying to filter the records on the sub forms - including syncronizing them together, based on the information in the main form.
The catch:
- the main form is not bound to a table
- the sub forms must filter based on information entered in an unbound text box on the main form. The trigger is a find button.
I have tried setting the subform filter with
Forms!Mainform!subform!filter property - access does not recogize the object.
I have also tried using the on current property in the subform but since the main form is not bound to a record the on current property event does not trigger.
I am open to suggestions.
The catch:
- the main form is not bound to a table
- the sub forms must filter based on information entered in an unbound text box on the main form. The trigger is a find button.
I have tried setting the subform filter with
Forms!Mainform!subform!filter property - access does not recogize the object.
I have also tried using the on current property in the subform but since the main form is not bound to a record the on current property event does not trigger.
I am open to suggestions.