Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Selecting a dropdown fills the address Selecting a dropdown fills the address
Register FAQ

Reply
 
Thread Tools Display Modes
  #1  
Old 04-25-2018, 08:06 PM
krishnamurthy.ka2810 krishnamurthy.ka2810 is offline Selecting a dropdown fills the address Windows 10 Selecting a dropdown fills the address Office 2016
Novice
Selecting a dropdown fills the address 		 
Join Date: Apr 2018
Posts: 6
krishnamurthy.ka2810 is on a distinguished road
Default Selecting a dropdown fills the address
When I click on a dropdown using Content control, I want the other content control to be automatically populated with address. Can anyone please help?
Reply With Quote
  #2  
Old 04-25-2018, 08:59 PM
gmayor's Avatar
gmayor gmayor is offline Selecting a dropdown fills the address Windows 10 Selecting a dropdown fills the address Office 2016
Expert
  
Join Date: Aug 2014
Posts: 4,101
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default
What does the first content control contain and what address are you referring to?
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
  #3  
Old 04-25-2018, 10:16 PM
macropod's Avatar
macropod macropod is offline Selecting a dropdown fills the address Windows 7 64bit Selecting a dropdown fills the address Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,962
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:
https://www.msofficeforums.com/word-...html#post46903
and, for different elements from a selected item to be output to different content controls, see:
https://www.msofficeforums.com/word-...tml#post120392
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #4  
Old 04-25-2018, 11:49 PM
krishnamurthy.ka2810 krishnamurthy.ka2810 is offline Selecting a dropdown fills the address Windows 10 Selecting a dropdown fills the address Office 2016
Novice
Selecting a dropdown fills the address 		 
Join Date: Apr 2018
Posts: 6
krishnamurthy.ka2810 is on a distinguished road
Default Doesn't autopopulate if it has a item
Hi Paul,

If there are multiple items in the drop down, and if I specify the value of item it doesnt auto populate
Reply With Quote
  #5  
Old 04-25-2018, 11:51 PM
macropod's Avatar
macropod macropod is offline Selecting a dropdown fills the address Windows 7 64bit Selecting a dropdown fills the address Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,962
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
It does in the sample attached to the post. If that's not happening in your document, there's an implementation issue.

PS: Please keep your posts on this topic in your original thread to which I've moved your reply.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #6  
Old 04-25-2018, 11:58 PM
krishnamurthy.ka2810 krishnamurthy.ka2810 is offline Selecting a dropdown fills the address Windows 10 Selecting a dropdown fills the address Office 2016
Novice
Selecting a dropdown fills the address 		 
Join Date: Apr 2018
Posts: 6
krishnamurthy.ka2810 is on a distinguished road
Default The value doesn't auto populate if the dropdown text has value
Hi macropod,

Please see the attached document.
I have Client and ClientDetails. If I select the Client, the Clientdetails doesn't autopopulate.
Attached Files
File Type: docm NDA NEW.docm (39.2 KB, 12 views)
Reply With Quote
  #7  
Old 04-26-2018, 12:39 AM
macropod's Avatar
macropod macropod is offline Selecting a dropdown fills the address Windows 7 64bit Selecting a dropdown fills the address Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,962
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
There is no apparent 'Client' content control in your document to trigger the update.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #8  
Old 04-26-2018, 12:39 AM
krishnamurthy.ka2810 krishnamurthy.ka2810 is offline Selecting a dropdown fills the address Windows 10 Selecting a dropdown fills the address Office 2016
Novice
Selecting a dropdown fills the address 		 
Join Date: Apr 2018
Posts: 6
krishnamurthy.ka2810 is on a distinguished road
Default
Hi Macropod,

Can you please reply?
Reply With Quote
  #9  
Old 04-26-2018, 12:42 AM
macropod's Avatar
macropod macropod is offline Selecting a dropdown fills the address Windows 7 64bit Selecting a dropdown fills the address Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,962
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
I already did. How about trying a dose of patience?!
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #10  
Old 04-26-2018, 01:02 AM
gmayor's Avatar
gmayor gmayor is offline Selecting a dropdown fills the address Windows 10 Selecting a dropdown fills the address Office 2016
Expert
  
Join Date: Aug 2014
Posts: 4,101
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default
Quote:
Originally Posted by krishnamurthy.ka2810 View Post
I have Client and ClientDetails. If I select the Client, the Clientdetails doesn't autopopulate.
It never will, because the conditional statement is never true. Use instead

Code:
If UCase(.DropdownListEntries(i).Text) = UCase(.Range.Text) Then
The test here is case sensitive
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
Reply

Tags
autofill, dropdown, vba

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
Selecting a dropdown fills the address Conditional Formatting And Cell Fills Tartan Neil Excel 2 03-15-2017 12:03 AM
Mail Merge a Protected Form Maintaining Form Fills t/korean85 Word 1 04-07-2013 05:34 PM
Create template that auto-fills from excel spreadsheet m.buskirk5 Publisher 0 07-02-2012 03:09 PM
HELP! Outlook 2003 Address Books - multiple account address lists ukmonkeynuts Outlook 0 06-01-2011 06:18 AM
Selecting a dropdown fills the address Chart fills derohanes Excel 1 10-18-2009 06:18 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:07 AM.

Contact Us - Privacy Statement - Top

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