Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
How can I get a selection from a Drop Down to populate other field
I have a drop down box with options like Minnesota, Oregon, Rhode Island,
South Dakota. What I need is once a state is selected I want fields such as Phone Number and Address to automatically populate with the correct information. I am trying to avoid as many errors as possible by users. Any help would be greatly appreciated! |
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
How can I get a selection from a Drop Down to populate other field
You can use a REF field for this. See
http://gregmaxey.mvps.org/Repeating_Data.htm -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA http://word.mvps.org "kmt1984" wrote in message news I have a drop down box with options like Minnesota, Oregon, Rhode Island, South Dakota. What I need is once a state is selected I want fields such as Phone Number and Address to automatically populate with the correct information. I am trying to avoid as many errors as possible by users. Any help would be greatly appreciated! |
#3
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
How can I get a selection from a Drop Down to populate other field
Hi kmt1984,
For this to work, you'll need to protect the document for forms. Note too that a Dropdown formfield can only have 25 items. When designing the document make sure the drop-down formfield has its 'calculate on exit' option checked. Then, for each option, create a series of IF tests like: {IF{Dropdown1}= "Minnesota" "555-1234-678"} {IF{Dropdown1}= "Oregon" "555-3579-246"} etc where Dropdown1 is the bookmark name of the Dropdown formfield. Note: The field brace pairs (ie '{ }') for the above examples are created via Ctrl-F9 - you can't simply type them or copy & paste them from this message. -- Cheers macropod [MVP - Microsoft Word] "kmt1984" wrote in message news I have a drop down box with options like Minnesota, Oregon, Rhode Island, South Dakota. What I need is once a state is selected I want fields such as Phone Number and Address to automatically populate with the correct information. I am trying to avoid as many errors as possible by users. Any help would be greatly appreciated! |
#4
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
How can I get a selection from a Drop Down to populate other field
See also http://www.gmayor.com/SelectFile.htm
-- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org kmt1984 wrote: I have a drop down box with options like Minnesota, Oregon, Rhode Island, South Dakota. What I need is once a state is selected I want fields such as Phone Number and Address to automatically populate with the correct information. I am trying to avoid as many errors as possible by users. Any help would be greatly appreciated! |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Field to enter name which will populate throughout doc via REF fie | Microsoft Word Help | |||
Drop down field - how to save selection | Microsoft Word Help | |||
populate drop down values dynamically | Microsoft Word Help | |||
Auto populate a field? | Microsoft Word Help | |||
Creating a form..drop-down should populate other fields | New Users |