![]() |
|
#1
|
|||
|
|||
![]()
Hello,
I have a Word form that is set up like this: Name Address City, State Zip Phone In the name field, I have a drop down form field. I would like to have the remaining items (ie address, city state zip, phone) fill in automatically once the name is selected. Is this possible and if so, how do it I do? Thanks in advance for any help! |
#2
|
|||
|
|||
![]()
Instead of formfields, use IF fields testing on the results of your first field. You must name your first field for this to work and have "calculate on exit" checked in the properties.
|
#3
|
|||
|
|||
![]()
Thanks for the response!
I am having some difficulties with this. I set up a simple example with options 1 2 and 3 in the drop down box. It doesn't seem to change when the value in the pull down box is changed. Can you please verify my IF info is correct? In the below example my drop down box is called Test. { IF "Test" = "1" "True" "False" } Can you please advise as to what I'm doing wrong? Thanks! |
#4
|
||||
|
||||
![]()
Assuming your Dropdown formfield's bookmark is 'Name', you could use a series of fields coded as:
{IF{REF Name}= "Joe" "Joe's Address¶ City, State Zip¶ Phone"}{IF{REF Name}= "Fred" "Fred's Address¶ City, State Zip¶ Phone"}{IF{REF Name}= "Mick" "Mick's Address¶ City, State Zip¶ Phone"}{IF{REF Name}= "Bill" "Bill's Address¶ City, State Zip¶ Phone"} Note: The field brace pairs (ie '{ }') for the above examples are created in the body of the document via Ctrl-F9 (Cmd-F9 on a Mac) - you can't simply type them or copy & paste them from this message.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
![]() |
Thread Tools | |
Display Modes | |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Custom Form Action launches wrong form | RMNZ | Outlook | 3 | 03-07-2012 11:26 AM |
![]() |
LAssist2011 | Word | 5 | 12-14-2011 03:02 PM |
25 item max in drop down form | sonicvalley | Word | 0 | 07-26-2010 11:12 PM |
![]() |
chesspupil | Word VBA | 7 | 05-09-2010 05:43 AM |
form to form data transfer | fantomegl | Word VBA | 0 | 05-30-2009 10:28 PM |