Multiple Options with Drop Down boxes

R

Ray_Johnson

I have a protected form. One of the fields is a dropdown box with three
options (A, B, and C). I want to have another field show "Apples,"
"Bananas," or "Cherries" based on the A B or C selected in the first field.

I figure it has something to do with an IF field, but I can't understand how
to nest.

In other words,
IF Field1 = "A" "Apples" IF Field1 = "B" "Bananas" IF Field1 = "C"
"Cherries" ""

(Since it is a dropdown field, there would need a null string, right?)
 
D

Doug Robbins

Here's a macro that displays the autotext entry corresponding to an item
selected in a dropdown formfield:

' Macro created 15-11-97 by Doug Robbins to add the address corresponding to
a drop down name

Set myDrop = ActiveDocument.FormFields("Dropdown1").DropDown
Company = myDrop.ListEntries(myDrop.Value).Name
Address = ActiveDocument.AttachedTemplate.AutoTextEntries(Company).Value
ActiveDocument.FormFields("Text1").Result = Address


--
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top