Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.word.newusers
|
|||
|
|||
If field in forms
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 |
#2
Posted to microsoft.public.word.newusers
|
|||
|
|||
If field in forms
You shouldn't need the second drop down box at all. What you appear to need
is a conditional field (or fields) that give a result based on the content of the first field. Thus : {IF {Dropdown1} = "John Smith" "ARIBA"}{IF {Dropdown1} = "Jane Brown" "ARICS" } etc Check the 'calculate on exit' check box of Dropdown1 and when you select and tab out of the field the appropriate result will be written to the conditional field. See also http://www.gmayor.com/SelectFile.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org ab wrote: 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 |
#3
Posted to microsoft.public.word.newusers
|
|||
|
|||
If field in forms
To add to what Graham has said, if your dropdown offers only two choices
(the two you cited), you need only one IF field, as you can compare to either of the possibilities, and the TrueText and FalseText of that one field will take care of both eventualities. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "Graham Mayor" wrote in message ... You shouldn't need the second drop down box at all. What you appear to need is a conditional field (or fields) that give a result based on the content of the first field. Thus : {IF {Dropdown1} = "John Smith" "ARIBA"}{IF {Dropdown1} = "Jane Brown" "ARICS" } etc Check the 'calculate on exit' check box of Dropdown1 and when you select and tab out of the field the appropriate result will be written to the conditional field. See also http://www.gmayor.com/SelectFile.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org ab wrote: 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 |
#4
Posted to microsoft.public.word.newusers
|
|||
|
|||
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 |
#5
Posted to microsoft.public.word.newusers
|
|||
|
|||
If field in forms
There are three names and three qualifications.
"Doug Robbins - Word MVP" wrote in message ... 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 |
#6
Posted to microsoft.public.word.newusers
|
|||
|
|||
If field in forms
Reading through, I don't think I explained it very well.
The form has a drop-down box for the three people. Further down the form I have to enter their qualifications. One is RIBA, one is RICS, one is ACIAT. Depending on which of the three are required, I then put in the appropriate qualifiication. "ab" wrote in message ... There are three names and three qualifications. "Doug Robbins - Word MVP" wrote in message ... 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 |
#7
Posted to microsoft.public.word.newusers
|
|||
|
|||
If field in forms
With ActiveDocument.FormFields("Name").DropDown
If .ListEntries(.Value) = "John Smith" Then ActiveDocument.FormFields("Qualification").Result = "RIBA" ElseIf .ListEntries(.Value) = "Jane Brown" Then ActiveDocument.FormFields("Qualification").Result = "RICS" Else ActiveDocument.FormFields("Qualification").Result = "ACIAT" End If End With -- 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 ... Reading through, I don't think I explained it very well. The form has a drop-down box for the three people. Further down the form I have to enter their qualifications. One is RIBA, one is RICS, one is ACIAT. Depending on which of the three are required, I then put in the appropriate qualifiication. "ab" wrote in message ... There are three names and three qualifications. "Doug Robbins - Word MVP" wrote in message ... 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 |
#8
Posted to microsoft.public.word.newusers
|
|||
|
|||
If field in forms
Sorry but I don't think I've got the hang of this.
The drop-down box with the names works fine - I have that in the template. When I go to the box lower down the page where I want the qualification, I can't get this right. I have tried creating a new macro with the details (amended with the correct names, etc) but when I try to run it, I get "run time error 438, Object does not support this property". If I try to do an If field, I am not sure how to enter the info. Thanks for your help. "Doug Robbins - Word MVP" wrote in message ... With ActiveDocument.FormFields("Name").DropDown If .ListEntries(.Value) = "John Smith" Then ActiveDocument.FormFields("Qualification").Result = "RIBA" ElseIf .ListEntries(.Value) = "Jane Brown" Then ActiveDocument.FormFields("Qualification").Result = "RICS" Else ActiveDocument.FormFields("Qualification").Result = "ACIAT" End If End With -- 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 ... Reading through, I don't think I explained it very well. The form has a drop-down box for the three people. Further down the form I have to enter their qualifications. One is RIBA, one is RICS, one is ACIAT. Depending on which of the three are required, I then put in the appropriate qualifiication. "ab" wrote in message ... There are three names and three qualifications. "Doug Robbins - Word MVP" wrote in message ... 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 |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Field codes not updating | Microsoft Word Help | |||
Forms in Word don't send the field information...How do I fix? | Microsoft Word Help | |||
printing forms - no answer in field | Microsoft Word Help | |||
Compile/Analyze Word Form Field data from multiple forms? | Microsoft Word Help |