#1   Report Post  
beckster02
 
Posts: n/a
Default drop down form fields

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?
  #2   Report Post  
Greg Maxey
 
Posts: n/a
Default

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

--
Greg Maxey/Word MVP
See:
http://gregmaxey.mvps.org/word_tips.htm
For some helpful tips using Word.

beckster02 wrote:
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?



Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Blank return for drop-down form fields Peter B. Microsoft Word Help 4 January 26th 07 05:01 PM
How do I use a form then mailmerge without losing the form fields Someone who's stuck Mailmerge 1 June 23rd 05 10:01 AM
Having multiple form fields automatically updated jrwaguespack Microsoft Word Help 3 March 25th 05 07:43 AM
Size of Drop Down Form Fields KSS Microsoft Word Help 1 February 24th 05 09:22 AM
Email a protected document that contains Text Form Fields Dowza New Users 1 January 8th 05 10:31 AM


All times are GMT +1. The time now is 08:54 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"