Drop-Down Field

[Gretchen]

I have a form with several drop-down boxes. Is there any way I can have one drop down box change by another drop down boxes answer? For example when I make a choice to one can the next one be defined to the last answer?
Bank: 01 (answer) Default to : Branch: 00 (answer)
01
or if I answer 24 under bank can I get the Branch drop down field to default to those branch #'s??

 

[Cindy M -WordMVP-]

Hi =?Utf-8?B?R3JldGNoZW4=?=,

You could use a macro (assigned to the "Exit macro" for a dropdown) to do it, yes. The macro would have to
- unprotect the form
- make the changes to the dropdown
- reprotect the form

Steps 1 and 3 you'll find in the forms part of my website. You should be able to record Step 2, for the most part, and "fit it into" the framework.

To test the value of a particular dropdown, use

If ActiveDocument.FormFields("Name").Result _
= "01" Then
'Put the recorded code here to change a dropdown
End If

I have a form with several drop-down boxes. Is there any way I can have one drop down box change by another drop down boxes answer? For example when I make a choice to one can the next one be defined to the last answer?
Bank: 01 (answer) Default to : Branch: 00 (answer)
01
or if I answer 24 under bank can I get the Branch drop down field to default to those branch #'s??

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep 30 2003)
http://www.mvps.org/word

This reply is posted in the Newsgroup; please post any follow question or reply in the newsgroup and not by e-mail