View Single Post
  #3   Report Post  
Posted to microsoft.public.word.newusers
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default If field in forms

Do you want the user to be able to select an alternate qualification from
the second DropDown, or is the qualification intended to be fixed based on
the name selected in the first DropDown?

If that is not the case, it would be better to use a Text FormField for the
qualification and run a macro on exit from the Drop Down to determine the
entry that was selected and then use the .Result property of the Text
FormField to display the appropriate qualification.

If there are only a couple of entries in the DropDown list, an If field
could be used

With ActiveDocument.FormFields("Name").DropDown
If .ListEntries(.Value) = "John Smith" Then
ActiveDocument.FormFields("Qualification").Result = "ARIBA"
Else 'Jane Brown was selected
ActiveDocument.FormFields("Qualification").Result = "ARICS"
End If
End With

but if there are many more than that, then it may be better to use a Select
Case construction.



--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"ab" wrote in message
...
I have created a form to be filled in using Word 2003. I have two drop-down
boxes which I need to link somehow.

What I want to do is:

If the name in the first drop-down box is "John Smith"

The qualification in the next drop-down box is "ARIBA"

If the name in the first drop-down box is "Jane Brown",

The qualification in the next drop-down box is "ARICS"

Help would be appreciated please.

TIA