Cascading Dropdowns

[camdameron]

Hi there,
I am trying to implement dependent dropdowns in a word form. I have a list of issues that have categories associated with them:

Preparation Issue- Air not Removed
Preparation Issue- Stock ran out

Shipment Issue- Product Quantity
Shipment Issue- Product Type
Shipment Issue- MIscellaneous

I am using some code that I received off of a post in this website and I applied it to my situation but I am unsure of a couple things:
1.) Does this code apply to non-legacy tools? I want to use the drop down list tool for word 2007. Is this not allowed?
2.) the code on the attached is getting a runtime error and prompts me to debug. when i remove the spaces from "PreparationIssue" it is no longer red, but I do not know what I am doing wrong.

I do not write much code (obviously) but I am eager to learn if you have any expertise to impart.

I thank you in advance!

Cameron

[camdameron]

what would be even better is if I could link the dependent lists on the form to an already established list in excel that, if modified in excel, would automatically modify the dropdowns in the form.

Is that possible?

Thanks again!