Thread: [Solved] Drop Down Boxes
View Single Post
 
Old 12-31-2010, 03:36 PM
macropod's Avatar
macropod macropod is offline Windows 7 32bit Office 2000
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,369
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

Hi Thomas,

Unless you need to be able to select a different phone # than the one determined by the name, there's no need for the second dropdown. All you need is a set of ordinary formula fields coded along the lines of:
{IF{REF Dropdown1}= "1stname" "123456"}
{IF{REF Dropdown1}= "2ndname" "234567"}
{IF{REF Dropdown1}= "3rdname" "345678"}
and so on, where 'Dropdown1' is the formfield's bookmark name (found via its 'properties - which you also set to 'calculate on exit') and 1stname, 2ndname, 3rdname are the actual names and the number strings are the phone numbers.

I've put all the fields on separate lines for clarity, but you can have them all on the same line - the fields for which there's no match simply won't display.

Note: The field brace pairs (ie '{ }') for the above example are created via Ctrl-F9 - you can't simply type them or copy & paste them from this message.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote