By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,253 Members | 1,652 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,253 IT Pros & Developers. It's quick & easy.

One FIlter for Multiple Sub forms

P: 41
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.

Feb 18 '08 #1
Share this Question
Share on Google+
1 Reply

Expert Mod 15k+
P: 31,768
For each subform, set the LinkChildFields & LinkMasterFields 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.
Feb 22 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.