Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-09-2017, 06:14 PM
ElfegoBaca ElfegoBaca is offline Document with drop down field for attorney. How to fill in the address etc in other fields. Windows 7 64bit Document with drop down field for attorney. How to fill in the address etc in other fields. Office 2010 64bit
Novice
Document with drop down field for attorney. How to fill in the address etc in other fields.
 
Join Date: May 2011
Posts: 5
ElfegoBaca is on a distinguished road
Default Document with drop down field for attorney. How to fill in the address etc in other fields.


I have a form with a drop down field with the name of 30 attorneys that we contact.

Once the attorney is chosen from the drop down field I would like the other fields to automatically get populated. These include

[Attorney Address]
[Attorney City][Attorney State][Attorney Zip]
[Attorney Tel]
[Attorney Fax]

However if the attorney is not in the drop down field then the other fields can be entered manually.

A second question related to the first is the following: Can a drop down field be entered manually if the choice is not in the drop down menu.

For example. Suppose there are 5 attorneys in the drop down field but the document will have a new attorney's name, is there a way for a field to do double duty, both as a drop down and as a manual entry. This would help immensely.
Reply With Quote
  #2  
Old 09-09-2017, 08:12 PM
Charles Kenyon Charles Kenyon is online now Document with drop down field for attorney. How to fill in the address etc in other fields. Windows 10 Document with drop down field for attorney. How to fill in the address etc in other fields. Office 2013
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,083
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

The answer is that what you request could be done.
For me, it would be a major amount of work (i.e. a couple of month devoted to doing it). I expect that professional Word programmers probably would find it easier, but not trivial. I expect that much would have to be done each time you wanted to change the data in the list.

A combobox allows a drop-down list that you can type in something not found in the list.

The way I would approach this would be to have a data table in Excel and use Mail Merge.
Reply With Quote
  #3  
Old 09-09-2017, 10:52 PM
gmayor's Avatar
gmayor gmayor is offline Document with drop down field for attorney. How to fill in the address etc in other fields. Windows 10 Document with drop down field for attorney. How to fill in the address etc in other fields. 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

You can do it with macros easily enough and this echoes similar work I have done for the US legal sector in the past.

I would store all the fields required in a dedicated Excel worksheet for ease of maintenance. The attached has just a couple of fields, but demonstrates the methodology. You can add fields to the worksheet and bookmarks to the document to reflect those fields and write the values to the bookmarks as shown.

Put both attachments in the same folder and create a new document from the template. The userform is displayed. The combo box is filled with the data from the worksheet. select an entry and click Continue to write the data to the document.

You will find more on filling comboboxes and userforms on my web site.
Attached Files
File Type: dotm Attorney.dotm (37.7 KB, 36 views)
File Type: xlsx Example.xlsx (9.1 KB, 31 views)
__________________
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
  #4  
Old 09-27-2017, 09:00 AM
Artimae Artimae is offline Document with drop down field for attorney. How to fill in the address etc in other fields. Windows 10 Document with drop down field for attorney. How to fill in the address etc in other fields. Office 2016
Novice
 
Join Date: Sep 2017
Posts: 4
Artimae is on a distinguished road
Default

Gmayor,
First of all, I am new to working with macros. I have a document that I have to update student progress on a daily basis. I am simply trying to create a dropdown box with a list student names to speed this process up. I have tried to adapt your Attorney.dotm and example.xlsx from above, but with no luck. Any help would be appreciated.
Reply With Quote
Reply

Tags
if then else, mail merge, tables

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Attorney address in the left margin. kshlomo Word 3 03-05-2017 03:35 PM
Using Fill In Fields to Autopopulate Multiple Areas in the Document rogelinepaula Word 1 08-13-2015 11:15 PM
Document with drop down field for attorney. How to fill in the address etc in other fields. Fill Word fields as well as edit document Chim20 Word 1 11-10-2014 01:48 PM
Populate Word Drop-down list with Excel column then auto fill form fields with Excel data Faldinio Word VBA 7 10-19-2014 06:03 AM
Document with drop down field for attorney. How to fill in the address etc in other fields. Nested if field that contains a fill-in field is not prompting for fill-in info Nccadm Mail Merge 2 04-02-2013 03:15 AM

Other Forums: Access Forums

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