drop down form fields

[Guest]

Is there a way I can have a user select an option in a drop down menu, and
have that selection change the results in other fields to predetermined
values?

 

[Greg Maxey]

Yes. You can do it with a macro that runs on exit from the formfield.

Here is an example that sets the value of a table cell range based on the
result in a formfield. You can easily adapt it to set the value of another
formfield:

Sub EvaluateFormFieldContent()
'
ActiveDocument.Unprotect
With ActiveDocument
If .FormFields("MartialStatus").Result = "Yes" Then
.Tables(1).Cell(1, 3).Range = "Skip to step 8"
Else
.Tables(1).Cell(1, 3).Range = "Skip to step 13"
End If
End With
ActiveDocument.Protect Type:=wdAllowOnlyFormFields, NoReset:=True
End Sub