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?

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.

Attached Files

Mapped dropdown Content Control.docx (24.0 KB, 14 views)

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia

That worked perfectly - thank you so much!!!