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

Filter a subform based on a list box

P: 4
I'm relatively new to access, and I'm trying to create a form where if I click on a selection of a list box the subform below it will be filtered automatically on click (I was hoping I didn't need a seperate "Filter" command button on the side, but I guess that would work just as well).

The list box is titled List46, and has two columns (let's just say column A and column B), and the subform is titled [Query1 Subform2], and has 10 columns that are based on a previous query of 3 tables. I would like it so that the subform would filter so that it's second column would match column A from the list box once I click on the listbox.

Can anyone help me? I would be so grateful. Thank you!
Jul 23 '09 #1
Share this Question
Share on Google+
2 Replies

Expert 100+
P: 1,287
Use the Link Master Fields and Link Child Fields of the subform properties. In Link Master Fields, put the name of the list box control. In Link Child Fields, put the name of the Field in the subform. Then, only records with a field value equal to the value of the list box will be displayed.
Jul 23 '09 #2

P: 4
Thank you so much that was extremely helpful
Jul 23 '09 #3

Post your reply

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