Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-31-2012, 03:48 PM
jwm1346 jwm1346 is offline Drop Down Form Help Mac OS X Drop Down Form Help Office 2012
Novice
Drop Down Form Help
 
Join Date: Nov 2011
Posts: 8
jwm1346 is on a distinguished road
Default Drop Down Form Help

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!
Reply With Quote
  #2  
Old 07-31-2012, 03:59 PM
Charles Kenyon Charles Kenyon is offline Drop Down Form Help Windows Vista Drop Down Form Help Office 2010 32bit
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,124
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

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.
Reply With Quote
  #3  
Old 07-31-2012, 06:39 PM
jwm1346 jwm1346 is offline Drop Down Form Help Mac OS X Drop Down Form Help Office 2012
Novice
Drop Down Form Help
 
Join Date: Nov 2011
Posts: 8
jwm1346 is on a distinguished road
Default

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!
Reply With Quote
  #4  
Old 07-31-2012, 07:49 PM
macropod's Avatar
macropod macropod is offline Drop Down Form Help Windows 7 64bit Drop Down Form Help 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

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]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Custom Form Action launches wrong form RMNZ Outlook 3 03-07-2012 11:26 AM
Drop Down Form Help Form Fields - Create blank form text field with if statement? 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
Drop Down Form Help Form Field - Drop down selection causing auto text 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

Other Forums: Access Forums

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