Filtering records on a subform
Posted on 2011-02-27
I have a Master Form. On 2 separate tabs I have a sub form on each. I want to be able to see all records related to the Master on SubformA and on SubformB only the records related to subformA.
To do this I:
Set the supporting query of subformB with criteria
[Forms]![Master]![SubFormA].[Form]![ID] ‘& FieldID which is the link between subforms A and B
I setup an ONCurrent Event on the FORM of subformB:
When I click on tab 3(SubFormB), the First record of subformA shows. If I change the view of the form to datasheet view…the correct records show.
After all that buildup….. How can I only see the records associated with subformA when I click on subform B.