Master/Child links for Main form with three subforms (1 Viewer)

[Pat Hartman]

This application shows how to use master/child links as well as criteria in subform RecordSource queries to sync three subforms to a bound main form. Members is the top level subform and dependents is the lowest level subform. The third subform is used to show that you can also drill down more and in this case, it just repeats a SINGLE row of the Dependents subform. To make the split logical, I made the Dependents subform not allow editing. Therefore to edit a Dependent record, you click on it to show it in the Dependent Edit Form and you can edit it there.

Pay attention to the property settings and the little bits of code here and there that make the four forms work in sync.