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

MS Access Combo Boxes & SubForms

P: 4
I have a Main Form with a combo box at the top. The combo box has 6 different values it reads from a table. I have 6 subforms which I have already built. Depending on the value selected in the combo box I want to display directly below the combo box its corresponding subform. Can someone please give me an example of how I would do this?
Oct 11 '07 #1
Share this Question
Share on Google+
1 Reply


nico5038
Expert 2.5K+
P: 3,072
Use the combo's AfterUpdate event to set the ObjectSource of the subform to the value of the combobox.

Personally I wouldn't use this setup, but use a tab control with six tabs and on each tab the subform.
Instead of the "complex" selection from a combobox the user now only has to press a button...

Nic;o)
Oct 11 '07 #2

Post your reply

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