Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-22-2020, 01:45 PM
Kiwi den Kiwi den is offline Name and Address Drop down Box Windows 10 Name and Address Drop down Box Office 2016
Novice
Name and Address Drop down Box
 
Join Date: Jan 2020
Posts: 6
Kiwi den is on a distinguished road
Default Name and Address Drop down Box

Hi All,

Can someone please direct me to or help me with putting a drop down box that when Client selected, inserts addrerss details below drop down box please,


Also I would like to put 2 drop down boxes beside each other, one for client name and a separate one for delivery address so if different for postal address, can be inserted

Thanks in advance
Reply With Quote
  #2  
Old 01-22-2020, 02:16 PM
macropod's Avatar
macropod macropod is offline Name and Address Drop down Box Windows 7 64bit Name and Address Drop down Box Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
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, for example:
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
  #3  
Old 01-22-2020, 02:32 PM
Kiwi den Kiwi den is offline Name and Address Drop down Box Windows 10 Name and Address Drop down Box Office 2016
Novice
Name and Address Drop down Box
 
Join Date: Jan 2020
Posts: 6
Kiwi den is on a distinguished road
Default

Sorry if I was vague with question, was wanting

1st drop down list to be able to pick client, and their details (1) will fill
(2,3,4,5)
2nd drop down list to be able to pick Company details (A) will fill (B,C,D,E)

Would like to to be set out with both lists beside each other on the page, list1 left indent and list 2 right indent

[drop down list 1] [Drop down list 2]
1 - MR Client A- Company detail
2- His street B- Their Street
3- His suburb C- Their Suburb
4- His town D- Their town
5- His Country E- Their Country
Reply With Quote
  #4  
Old 01-22-2020, 02:34 PM
macropod's Avatar
macropod macropod is offline Name and Address Drop down Box Windows 7 64bit Name and Address Drop down Box Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
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

The links I posted already address that for a single dropdown. Only minor modifications would be needed to cater for a second dropdown.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #5  
Old 01-22-2020, 02:42 PM
Kiwi den Kiwi den is offline Name and Address Drop down Box Windows 10 Name and Address Drop down Box Office 2016
Novice
Name and Address Drop down Box
 
Join Date: Jan 2020
Posts: 6
Kiwi den is on a distinguished road
Default

`Yip, have this, but I cannot figure how to get second list to the right indent beside the first,
Reply With Quote
  #6  
Old 01-22-2020, 03:01 PM
macropod's Avatar
macropod macropod is offline Name and Address Drop down Box Windows 7 64bit Name and Address Drop down Box Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
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

The simplest approach is to use a two-column table and export each content control's output to the relevant cell. Do that and you don't even need a content control to act as a container for the output.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #7  
Old 01-22-2020, 08:05 PM
macropod's Avatar
macropod macropod is offline Name and Address Drop down Box Windows 7 64bit Name and Address Drop down Box Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
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

Now also cross-posted - without even bothering to acknowledge the answer provided here - at: Drop down lists in seperate columns | Microsoft Office Forums
For cross-posting etiquette, please read: Excelguru Help Site - A message to forum cross posters
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #8  
Old 01-22-2020, 08:18 PM
Kiwi den Kiwi den is offline Name and Address Drop down Box Windows 10 Name and Address Drop down Box Office 2016
Novice
Name and Address Drop down Box
 
Join Date: Jan 2020
Posts: 6
Kiwi den is on a distinguished road
Default

I could not log onto this site for 4 hours, and need an answer, what you gave me had not worked so needed advice, as I am trying to get things sorted so I can use this, as am sorting some international deliveries, and aware of the time zone differences am still trying to get an answer that will work
Reply With Quote
  #9  
Old 01-22-2020, 08:31 PM
macropod's Avatar
macropod macropod is offline Name and Address Drop down Box Windows 7 64bit Name and Address Drop down Box Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
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 Kiwi den View Post
am still trying to get an answer that will work
Which is precisely what the answer I've give does...
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #10  
Old 01-22-2020, 09:37 PM
Kiwi den Kiwi den is offline Name and Address Drop down Box Windows 10 Name and Address Drop down Box Office 2016
Novice
Name and Address Drop down Box
 
Join Date: Jan 2020
Posts: 6
Kiwi den is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
Which is precisely what the answer I've give does...
Don't know what I'm doing wrong, but all I get if 1st drop-down is used, then I get a non delimitated list, in both 1st and 2nd lists, same if I use drop down list 2
Reply With Quote
  #11  
Old 01-22-2020, 10:09 PM
macropod's Avatar
macropod macropod is offline Name and Address Drop down Box Windows 7 64bit Name and Address Drop down Box Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
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 attached.
Attached Files
File Type: zip Content Controls - 2 Dropdowns with Dependent Text.zip (33.5 KB, 12 views)
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #12  
Old 01-24-2020, 06:02 PM
Kiwi den Kiwi den is offline Name and Address Drop down Box Windows 10 Name and Address Drop down Box Office 2016
Novice
Name and Address Drop down Box
 
Join Date: Jan 2020
Posts: 6
Kiwi den is on a distinguished road
Default

Thanks so much, got computer fixed and now works a treat, appreciate it
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Name and Address Drop down Box MAIL Merge - Site Address / Invoice address mgsjarvis Mail Merge 3 09-25-2018 02:43 PM
Document with drop down field for attorney. How to fill in the address etc in other fields. ElfegoBaca Word 3 09-27-2017 09:00 AM
Add link to email address that hides the actual address or makes it inaccessible to online bots richiebabes Word 1 09-03-2014 03:22 PM
Name and Address Drop down Box How to forward all e-mails from one address to five (5) other e-mail address? adi2012 Outlook 1 09-09-2012 06:41 PM
HELP! Outlook 2003 Address Books - multiple account address lists ukmonkeynuts Outlook 0 06-01-2011 06:18 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:52 AM.


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