469,890 Members | 1,448 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,890 developers. It's quick & easy.

MS Access Combo Boxes & SubForms

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
1 1205
3,080 Expert 2GB
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...

Oct 11 '07 #2

Post your reply

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

Similar topics

12 posts views Thread by Mike MacSween | last post: by
reply views Thread by M. Farrenkopf | last post: by
22 posts views Thread by Bob Darlington | last post: by
1 post views Thread by flamethrower01 | last post: by
2 posts views Thread by egoldthwait | last post: by
1 post views Thread by Waqarahmed | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.