Connecting Tech Pros Worldwide Forums | Help | Site Map

Sub Menus in Access

TheThrill
Guest
 
Posts: n/a
#1: Nov 12 '05
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?

Klaus Oberdalhoff [MVP]
Guest
 
Posts: n/a
#2: Nov 12 '05

re: Sub Menus in Access


Hi,

you must set the rowsource of the next combo depending from the
afterupdate-value of the "actual" combo .

--
mfg

Klaus Oberdalhoff [MVP]


TheThrill wrote:[color=blue]
> 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?[/color]

Closed Thread