Is it at all possible to create a double drop down from field ....

I am trying to create a drop down that will narrow the choices to the second
drop down....

Example : If you choose chocolat then the second drop down will not have any
pepper and salt to it


Thanks for your help

Yes it is possible. Run a macro similiar to the following on entry to the
subordinate formfield:

Sub SetDDValue()
Dim oFld As FormField
Set oFld = ActiveDocument.FormFields("Dropdown2")
Select Case ActiveDocument.FormFields("Dropdown1").Result
Case "Chocolate"
oFld.DropDown.ListEntries.Add ("Sugar")
oFld.DropDown.ListEntries.Add ("Milk")
oFld.DropDown.ListEntries.Add ("Cocoa")
Case "Beans"
oFld.DropDown.ListEntries.Add ("Salt pork")
oFld.DropDown.ListEntries.Add ("Onions")
Case Else
'Do Nothing'
End Select
End Sub


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


Dyno wrote:
Is it at all possible to create a double drop down from field ....

I am trying to create a drop down that will narrow the choices to the
second drop down....

Example : If you choose chocolat then the second drop down will not
have any pepper and salt to it


Thanks for your help

Thanks for your help .....Much appreciated
"Greg Maxey" wrote in message
...
Yes it is possible. Run a macro similiar to the following on entry to the
subordinate formfield:

Sub SetDDValue()
Dim oFld As FormField
Set oFld = ActiveDocument.FormFields("Dropdown2")
Select Case ActiveDocument.FormFields("Dropdown1").Result
Case "Chocolate"
oFld.DropDown.ListEntries.Add ("Sugar")
oFld.DropDown.ListEntries.Add ("Milk")
oFld.DropDown.ListEntries.Add ("Cocoa")
Case "Beans"
oFld.DropDown.ListEntries.Add ("Salt pork")
oFld.DropDown.ListEntries.Add ("Onions")
Case Else
'Do Nothing'
End Select
End Sub


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


Dyno wrote:
Is it at all possible to create a double drop down from field ....

I am trying to create a drop down that will narrow the choices to the
second drop down....

Example : If you choose chocolat then the second drop down will not
have any pepper and salt to it


Thanks for your help