Drop Down Form Fields

[JWM1346]

I have three Drop Down boxes with different values in each (a name in one, street address in one and city and state in last). Is it possible that when an item is selected in the first one, the other two boxes automatically fill in with the correct information?

 

[cyrilbrd]

maybe not...

or at least you can set a drop down to limit it's choice to a specific range depending on the value in the first drop down, data validation / list then in the range use a formula such as: IF(firstDV="this",RANGE1,IF(firstDV="that",RANGE2))

DV being Data validation or drop down list.

Is this what you are referring to?

 

[JWM1346]

No. I need then to update automatically. Its in a Word doc, not Excel. I was given the wrong information.

 

[cyrilbrd]

nope you are in the wrong forum...

 

[Macropod]

You can do this in Word with one DropDown FormField and two sets of formula fields. Assuming the DropDown FormField has the names and has an internal bookmark 'Dropdown1'. Then, if you checke the DropDown FormField's 'calculate on exit' property, you can use formula fields coded like:
{IF{REF Dropdown1}= "Joe Blow" "Joe Blow's street address"}
{IF{REF Dropdown1}= "John Doe" "John Doe's street address"}

{IF{REF Dropdown1}= "Joe Blow" "Joe Blow's city & state"}
{IF{REF Dropdown1}= "John Doe" "John Doe's city & state"}

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.