Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-22-2020, 03:43 PM
Pestomania Pestomania is offline Dependent Field Windows 10 Dependent Field Office 2010
Novice
Dependent Field
 
Join Date: Dec 2020
Posts: 5
Pestomania is on a distinguished road
Default Dependent Field


Hello Everyone,

I have a field called "Company_1" and a field called "Address_1".

I would like "Address_1" to autopopulate based on "Company_1". I have attached a sample document. Can anyone help?
Attached Files
File Type: docx Test Document.docx (24.5 KB, 6 views)
Reply With Quote
  #2  
Old 12-22-2020, 07:07 PM
Guessed's Avatar
Guessed Guessed is offline Dependent Field Windows 10 Dependent Field Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,978
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

Have a look at this thread for a method of doing this.
https://www.msofficeforums.com/word-...drop-down.html
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #3  
Old 12-22-2020, 11:40 PM
macropod's Avatar
macropod macropod is offline Dependent Field Windows 10 Dependent Field Office 2010
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
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

See:
Multiple entries in dropdown lists
and, for different elements from a selected item to be output to different content controls, see:
Multiple entries in dropdown lists - Page 5
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #4  
Old 12-23-2020, 06:09 AM
Pestomania Pestomania is offline Dependent Field Windows 10 Dependent Field Office 2010
Novice
Dependent Field
 
Join Date: Dec 2020
Posts: 5
Pestomania is on a distinguished road
Default

I was finally able to get a different code to work. The instructions didn't state to download the excel and then make it work for you, but I have it working now.
Reply With Quote
  #5  
Old 12-23-2020, 12:25 PM
macropod's Avatar
macropod macropod is offline Dependent Field Windows 10 Dependent Field Office 2010
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
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

Nothing in the links Andrew & I posted have anything to do with Excel because your own post mentioned nothing about any data coming from Excel.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #6  
Old 12-24-2020, 07:49 AM
Pestomania Pestomania is offline Dependent Field Windows 10 Dependent Field Office 2010
Novice
Dependent Field
 
Join Date: Dec 2020
Posts: 5
Pestomania is on a distinguished road
Default

HI,

It helps when I include the link that I used:

Link "Conditional Content" to a List Selection
Reply With Quote
  #7  
Old 12-24-2020, 08:03 AM
gmaxey gmaxey is offline Dependent Field Windows 10 Dependent Field Office 2016
Expert
 
Join Date: May 2010
Location: Brasstown, NC
Posts: 1,429
gmaxey is a jewel in the roughgmaxey is a jewel in the roughgmaxey is a jewel in the roughgmaxey is a jewel in the rough
Default

The instructions did say ....
Attached Images
File Type: png 2020-12-24_10-01-57.png (29.0 KB, 11 views)
__________________
Greg Maxey
Please visit my web site at http://www.gregmaxey.com/
Reply With Quote
  #8  
Old 12-24-2020, 08:20 AM
Pestomania Pestomania is offline Dependent Field Windows 10 Dependent Field Office 2010
Novice
Dependent Field
 
Join Date: Dec 2020
Posts: 5
Pestomania is on a distinguished road
Default

Yes, I when I reread the instructions, I was able to get it to work. It's a great program that works perfectly.

Now I am trying to add a "select image and move to front" whenever I change the company.
Reply With Quote
  #9  
Old 12-24-2020, 11:35 PM
macropod's Avatar
macropod macropod is offline Dependent Field Windows 10 Dependent Field Office 2010
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
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

Quote:
Originally Posted by Pestomania View Post
It helps when I include the link that I used:
It would help even more if you properly specified the task at the outset.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Can a text form field be dependent on a drop-down? scannella Word 4 07-31-2019 03:36 PM
Dependent form pepemujica Word 2 04-17-2017 05:23 PM
make text form field active dependent on dropdown Glenn0004 Word VBA 1 06-23-2015 06:13 PM
Dependent Field VLOOKUP is dependent up IF function dmccrar Excel 2 09-14-2014 09:51 AM
Auditing Dependent Cells WildBill Excel 2 09-07-2011 10:14 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:36 PM.


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