Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Oct 2013
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Post Word 2010 - Multiple Dependent Drop-down Issues

    To say that I'm a Word Macro newbie would be an understatement, but I'm desperately trying to create multiple dependent drop-downs in a single document. The form is an HR-type form in which the user will select a particular employment stream, and then a subsequent classification within the selected stream. I would like the user to have the ability to choose three classifications in total, from different streams, if desired.

    i.e.

    Choose up to three classfications:

    Stream Drop-Down 1 Classification Drop-Down 1
    Stream Drop-Down 2 Classification Drop-Down 2
    Stream Drop-Down 3 Classification Drop-Down 3


    I've created the first level of dependent drop-downs without issue. You select the stream, and the correct corresponding relevant selections are appearing in the classification drop-down.

    I created the second level of drop-downs (which are to be completely independent from the top ones), but the correct corresponding selections will only appear in the classification drop-down if I make the same selection twice from drop-down 1. For example:

    Select "Finance"................. Nothing appears in the Classification drop-down
    Select "Finance" again......... The Finance Classifications appear
    Select "HR"........................ The Finance Classifications appear
    Select "HR" again................ The HR Classifications appear
    Select "Procurement"........... The HR Classifications appear
    Select "Procurement" again... The Procurement Classifications appear... etc. etc.

    Why is my macro forcing me to choose the stream selection twice? The classifications are always one behind! I first copied and pasted my first macro beneath the End Sub, and renamed the drop-downs, and the issue occurred. So I tried creating the macro in its own module from scratch, but I'm getting the same issue. Advice?

    If it helps, here is the start of my first macro:

    Sub PopulateddClassifications()
    Select Case ActiveDocument.FormFields("ddStreams").Result
    Case "Stream 1 Office Support"
    With ActiveDocument.FormFields("ddClassifications").Dro pDown.ListEntries
    .Clear
    .Add "Clerk, Accounting"


    And here is the start of my second one:

    Sub PopulateddBClassifications()
    Select Case ActiveDocument.FormFields("ddBStream").Result
    Case "Stream 1 Office Support"
    With ActiveDocument.FormFields("ddBClassifications").Dr opDown.ListEntries
    .Clear
    .Add "Clerk, Accounting"


    Any help would be sincerely appreciated!

  2. #2
    New Lounger
    Join Date
    Oct 2013
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Since the formatting messed up, here's a screen shot of the actual start of the second macro:
    Macro2.jpg

  3. #3
    New Lounger
    Join Date
    Oct 2013
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Solved! It was such a silly error. I simply had neglected to choose the correct "exit" on the first drop-down.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •