#1
|
|||
|
|||
Is a Dependent Drop Down List the Best Way to Handle this?
Hi. I would like to add drop-down lists to a form. The first drop-down would have Department numbers and then the second drop-down would show a Fund code. For departments 950000-954000 the fund should be 225. For department 956900 the fund should be 569, department 957000 the fund should be 570, etc. If someone selects 956900 in the department drop-down, the only option I want to show in the Fund drop-down is 569. Is a dependent drop-down the best way to do this? If so what is the VBA code for this? |
#2
|
||||
|
||||
Sounds like there is no need for a dependent drop-down since the Fund code is completely determined by the Department.
You can map two Content Controls to the same xml element. The Department should be a Dropdown CC with entries for all the Departments and the value for each should be the associated fund number. Then the Fund should be a Plain text CC. I've attached a sample doc that demonstrates this.
__________________
Andrew Lockton Chrysalis Design, Melbourne Australia |
#3
|
|||
|
|||
Thank you
That worked perfectly - thank you so much!!!
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Creating an Auto-Generated Field dependent on Drop-Down List | daft21 | Word VBA | 1 | 07-26-2021 05:54 PM |
change header, footer information dependent on selection in drop down list | dogbural | Word VBA | 2 | 06-07-2020 04:12 PM |
Cascading drop-downs in Word with one parent menu and four dependent drop-downs | mrstrawhand | Word VBA | 3 | 03-30-2020 06:08 AM |
dynamic dependent drop down list based on input with reference to a two column table | jwan142 | Excel | 4 | 05-23-2018 08:15 AM |
Help with Vlookup in a Dependent drop down list | angelmr | Excel | 0 | 11-29-2016 09:25 AM |