Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-15-2016, 12:44 PM
Nukedaddy Nukedaddy is offline Dropdown boxes to multiple fields? Windows 7 64bit Dropdown boxes to multiple fields? Office 2010 64bit
Novice
Dropdown boxes to multiple fields?
 
Join Date: Jul 2016
Posts: 5
Nukedaddy is on a distinguished road
Default Dropdown boxes to multiple fields?

I need to create a single page form (template?) in Word. There are 2 things I need to do. One is a blank or box or ? where I put in the employee's name. If the name entry box had a prompt or rollover to tell the typist what goes there that would be great. When I enter it there, I want it to repeat itself at about 8 more locations on the same page or subsequent pages.
Then I want 2 drop-down boxes where I list position titles and team colors. These will also propagate to 8 other locations on the same form.


I apologize if I am asking these questions in "Dinosaurus Lex". It is the language of 60 year old Tyrannosaurs like me, with itty-bitty arms that barely reach a keyboard.

Any help here?
Reply With Quote
  #2  
Old 09-15-2016, 01:13 PM
Charles Kenyon Charles Kenyon is offline Dropdown boxes to multiple fields? Windows 8 Dropdown boxes to multiple fields? Office 2013
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,469
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

I am also over 60.
We need to distinguish between the dropdowns and the ones where you type in a single item.
You need to turn on the Developer Tab if you have not already done so.

The best solution I know of for typing something in one place and having it repeat is the "Document Property Content Control" that you insert using Insert > Quick Parts > Document Property. Scroll down to idea #7 in the following article for "Document Property Content Control" to see how to use this.
Repeating Data (Populating Multiple Like Fields)
This is only good for:
  1. Documents that will be used in Word 2007 or later, and
  2. Where you need 15 or fewer discrete pieces of information to be repeated.
A drop-down menu of choices adds a separate level of complexity. First, read the entire article, not just the part about document property content controls.
Here is another place for ideas: Making Forms with Microsoft Word


For the dropdown, I recommend using Greg Maxey's utility to insert a Mapped Content Control. There is a lot of programming that goes into that utility, but it spares you the programming and learning XML. Content Control Tools
With it, you can insert a Drop-down list which is mapped to an XML node in your document. If you then copy that content control to another place in the document, it will change in all other copies. (You could do this with the non-dropdown controls, as well.) To use it, you need to place the utility in your Word Startup Folder and look for it under the Add-Ins tab in Word.

Attached are screenshots of the menu to insert the document property content controls and of Greg's Content Control Tools dialog. Again, read the article on repeating data's section on this. The "property" names shown do not have to be what shows up in your document.
-
Attached Images
File Type: png 00 deleteme 1.png (32.5 KB, 59 views)
File Type: png 2010ContentControlTools.png (46.5 KB, 57 views)

Last edited by Charles Kenyon; 09-16-2016 at 09:42 AM.
Reply With Quote
  #3  
Old 09-15-2016, 03:33 PM
Charles Kenyon Charles Kenyon is offline Dropdown boxes to multiple fields? Windows 8 Dropdown boxes to multiple fields? Office 2013
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,469
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

Here are two screen shots showing how the mapped controls work using Greg's utility. By the way, the utility is only needed to write the document. It is not needed to use it.

The first screen shot shows the page as the drop-down is being used. The control shows "Steve" in two locations. The second screen shot shows it after the change to "Bill" is made. A change made to any one of these mapped controls is reflected in all copies in the document.
-
Attached Images
File Type: png 00 deleteme 2.png (9.7 KB, 60 views)
File Type: png 00 deleteme 3.png (5.0 KB, 60 views)
Reply With Quote
  #4  
Old 09-16-2016, 06:50 AM
Charles Kenyon Charles Kenyon is offline Dropdown boxes to multiple fields? Windows 8 Dropdown boxes to multiple fields? Office 2013
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,469
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

Because I answer similar questions frequently, I've created a web page summary that may be helpful. Mapped Content Controls and Document Properties
Reply With Quote
Reply

Tags
dropdowns, forms, templates



Similar Threads
Thread Thread Starter Forum Replies Last Post
Dropdown boxes to multiple fields? Multiple entries in dropdown lists paul_pearson Word VBA 151 10-18-2023 04:23 PM
Dropdown boxes to multiple fields? Linking WORD Cascading Dropdown Boxes to Excel music_al Word VBA 6 02-15-2016 03:56 PM
Dropdown boxes to multiple fields? Word 2013 cannot edit doc with dropdown fields wordcam Word 12 11-21-2014 07:03 PM
Dropdown boxes to multiple fields? Microsoft Word Form, DropDown Fields and Calculations Tracy Lynn Word VBA 2 09-29-2013 08:59 PM
Dropdown boxes to multiple fields? Microsoft Word Calculations and Dropdown Fields Tracy Lynn Office 4 06-26-2013 07:36 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:15 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft