G
Guest
hey all, newbie here. I want to know if you can make a combo box where you have 5 choices and depending on your choice another dropdown is populated with more specific choices? Thx for help in advance
-Hil
-Hil
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
Byron
Hill,
The short answer is "Yes." The longer answer is that you
can use a list from a table or a specific List of values
to populate your combo box. This is dependent on what
type of "Row Source" property you select.
Next you would write code or create a macro that would be
run by running this code or macro from the AfterUpdate
event of the first combo box. You would probably want to
use a Select Case statement so that you can populate the
second combo box based on the selection made in the first
combo box. You would simply set the "Row Source"
property of the second combo box.
HTH
Byron
choice another dropdown is populated with more specific
choices? Thx for help in advance.
The short answer is "Yes." The longer answer is that you
can use a list from a table or a specific List of values
to populate your combo box. This is dependent on what
type of "Row Source" property you select.
Next you would write code or create a macro that would be
run by running this code or macro from the AfterUpdate
event of the first combo box. You would probably want to
use a Select Case statement so that you can populate the
second combo box based on the selection made in the first
combo box. You would simply set the "Row Source"
property of the second combo box.
HTH
Byron
combo box where you have 5 choices and depending on your-----Original Message-----
hey all, newbie here. I want to know if you can make a
choice another dropdown is populated with more specific
choices? Thx for help in advance.