Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-13-2017, 05:15 PM
macropod's Avatar
macropod macropod is offline auto populate multiple text boxes dependent on a drop down Windows 7 64bit auto populate multiple text boxes dependent on a drop down Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

For the form-creation basics, see: https://support.office.com/en-us/art...B-AC44937E3A9F

Since you're working with Office 2007, I'd suggest using content controls, as described in that article.

Your requirements are far more involved than that basic introduction covers. Assuming you want to choose the State from a dropdown list and, depending on the State selected, choose a city from another dropdown list of the cities for that State, you'll need to implement a dependent dropdown. This requires some VBA programming. For a document with such a setup, for which the core programming has already been done for you, see:
https://www.msofficeforums.com/word-...html#post77762

For the contract number and hotel name, you'll need to implement a dependent text content control. This too requires some VBA programming. For a document with such a setup, for which the core programming has already been done for you, see:
https://www.msofficeforums.com/word-...html#post46903

From there, it's a fairly straightforward matter to replicate any of these details throughout the document. One method would be to bookmark each of the initial content controls and simply insert cross-references to those bookmarks wherever you need them. The code that handles the content control dependencies can likewise handle the cross-reference updating.

Doubtless you'll have more questions. Feel free to post back.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #2  
Old 03-17-2017, 05:54 PM
angelaschultz angelaschultz is offline auto populate multiple text boxes dependent on a drop down Windows 7 32bit auto populate multiple text boxes dependent on a drop down Office 2007
Novice
auto populate multiple text boxes dependent on a drop down
 
Join Date: Mar 2017
Posts: 4
angelaschultz is on a distinguished road
Talking it worked

OK so i used the second link you sent with the tags and values set as the contract number. It works beautifully. Now I am trying to reference the information throughout the document. I started by bookmarking the dropdown content control and cross referencing it on the next page. All it seems to have done was copy iy. What I mean is that there is another copy of the dropdown content control but the user would have to manually select the city here also instead of you changing it on the first page and it automatically populating the selected city name elsewhere.

Thoughts?
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
auto populate multiple text boxes dependent on a drop down Auto Populate Text On Dependent Drop Down Exit GregStewartPTC Word VBA 2 02-27-2017 05:37 AM
auto populate multiple text boxes dependent on a drop down How to populate dependent dropdowns and auto-fill text fields simultaneously? vera Word VBA 1 10-07-2016 07:41 PM
VBA coding for multiple drop-down lists to populate a text box for each list yeatropulo Word VBA 14 11-11-2015 01:08 PM
auto populate fields for multiple files w/in folder jbyrd Word 0 07-21-2014 07:35 AM
Auto populate text help i'm stuck! Word 1 08-13-2010 11:52 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:50 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