How to populate dependent dropdowns and auto-fill text fields simultaneously?

vera · #1 10-07-2016, 08:55 AM

I am using legacy fields to create a form in Word 2010. There will be well over 50 different fields in this form but I am focusing on about half. I have tried searching around the web for answers to my questions but have been unable to return any results.

I learn as I go so and I work on these forms when my workload is slow so it will sometimes be months before I can revisit a project; thus, my knowledge is quite limited. So the more descriptive the answer, the better J

I have 3 questions in total:

1. How do I auto-populate multiple dropdown lists (w/ the same selections) based on the selection of 1 dropdown list? Thus far, I have successfully created a dropdown list that has auto-filled a second dropdown list further down on the same page but I cannot figure out how to duplicate this dependent dropdown.

Action: Select option from first/main Dropdown “ddLocation” (12 choices)
Result: Dependent Dropdown1 “ddRequestor” auto-populates with 3 choices
Dependent Dropdown2 “ddRequestor1” auto-populates with the same 3 choices
Dependent Dropdown3 “ddRequestor2” auto-populates with the same 3 choices
… etc.

2. How do I auto-populate a text field/dynamic variable AND a dependent dropdown list at the same time?

Action: Select item from “ddLocation”
Result: Text Form Field “CC” (or DocVariable “{DocVariable CostCenter}”) auto-populates
“ddRequestor”, “ddRequestor1”, etc. auto-populates

3. How do I auto-populate multiple text fields based on the selection of a dependent dropdown?

Action: Select option from “ddRequestor”
Result: Text Field “Req_Tel” auto-fills
Text Field “Approver” auto-fills
Text Field “Appr_Tel” auto-fills

I’d prefer not to use DocVariables for this section since I will have a total of 25 unique selection options for the dependent dropdowns which would total the number of lines to 75. Currently, I have a table hidden at the bottom of my document which I would like to use, if possible.

Also, if there is a way to use this table (I can add another column with the locations & one more row for each location) as the source for the dependent dropdown lists as opposed to the VBA code, that would be ideal that way, in case of personnel change, there is only one location that would have to be edited instead of two. While ideal, this is not required.

I’ve attached a sample of the form I am working on. I left only the formfields that need to be populated through vba. The code I have is from Greg Maxey’s demo pack. (http://gregmaxey.com/word_tip_pages/link_content_to_dropdown_list.html)

Thanks in advance for any and all help!

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Retain format in dropdowns when unlinking fields	brent chadwick	Word VBA	2	09-08-2015 12:50 PM
Auto-populate key fields in an email?	ryebanana	Outlook	1	07-21-2015 04:25 AM
Populate Word Drop-down list with Excel column then auto fill form fields with Excel data	Faldinio	Word VBA	7	10-19-2014 06:03 AM
auto populate fields for multiple files w/in folder	jbyrd	Word	0	07-21-2014 07:35 AM
Auto-populate from form fields	kenelder	Word	3	05-23-2013 07:50 AM