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

Combo Box -- Sub Menu

P: n/a
I'm trying to develop a few combo boxes. When a user selects a choice
in Combo box "A" they have the choices "1, 2, 3, 4". Say they pick 3.
They must then go to combo box "B" and when they pick 3 (from A) it
only gives them the options "cat, dog, pig". However, if they were to
pick 2 in combo box "A" it would give them the option of "donkey,
horse, bear".

I am guessing it is soem VB code to make this happen. anyone have any
ideas?
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
You need to reference combo box "A" in the source query of combo box "B",
then in the after update event of combo box "A" requery combo box "B"

Me![b].Requery

I also disable combo box "B" until something is selected from combo box "A"
"TheThrill" <em************@yahoo.com> wrote in message
news:b2**************************@posting.google.c om...
I'm trying to develop a few combo boxes. When a user selects a choice
in Combo box "A" they have the choices "1, 2, 3, 4". Say they pick 3.
They must then go to combo box "B" and when they pick 3 (from A) it
only gives them the options "cat, dog, pig". However, if they were to
pick 2 in combo box "A" it would give them the option of "donkey,
horse, bear".

I am guessing it is soem VB code to make this happen. anyone have any
ideas?

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.