[kmt1984]

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!

[Suzanne S. Barnhill]

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!

[macropod[_2_]]

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!

[Graham Mayor]

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!