One FIlter for Multiple Sub forms

[patriciashoe]

I have a form that contains three related sub forms. The stored data can be from any number of years. At times I would like to filter the data so when the main form is open all the subform data shows the selected year. What is the best way to construct this? Right now I have a filter dropdown for one of the sub forms but there must be way to tie in all subforms. Thanks for pointing me in the right direction.

Patti

[NeoPa]

For each subform, set the LinkChildFields & LinkMasterField s properties to the fields that you want to match. This way, only the linked records will display and the main form filter automatically effects the subforms.