Linked pick list

Hi
I would like to create a form for users to fill in.
this includes a dropdown field [Product]
They select [Fruit] or [Vegetables]
as a result of that selection another dropdown field is enabled with
1 Fruit selection [Apple] [Pear] [Orange] ect or
2 Vegetables selection [Onion] [Beans] [Carrot]

i have seen this done as cascading combo boxs in other office products.
Can this be done in word 2007 please and is their any good examples i can work from.
i was thinking that if i could read the value when the user leaves the product dropdown
i could use select case or if to load the next dropdown.
Thanks for looking at this
Petr
petePrinterAsked:
Who is Participating?
 
GrahamSkanRetiredCommented:
Here is an example that uses 'Legacy' form fields.
FormsDropDowns.dot
0
 
GrahamSkanRetiredCommented:
It uses a VBA macro which runs when the first dropdown is exited. The document is protected for forms, but there is no password.

It can also be done with ActiveX controls, which are generally easier to program but don't look very good when printed. Also they are resource-hungry.

If you have a lot of selection to do, it may be worth putting the controls on to a Userform, thus separating the data selection process from the final document.
0
 
petePrinterAuthor Commented:
Graham
That you for the prompt reply and working example.
How do i set this up please?
0
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

 
petePrinterAuthor Commented:
Graham
Thank you
i missed you explanation first time sorry
0
 
GrahamSkanRetiredCommented:
If you don't have to support anything earlier that 2007, you might prefer the new Content controls. It isn't possible to upload a document with VBA macros, but if you want to pursue that, We could post the macro separately in a code snippet.
0
 
GrahamSkanRetiredCommented:
That must be a record for fast acceptance. Thanks.
0
 
petePrinterAuthor Commented:
Graham
Thanks only 2007is needed
 i will have a look at content control
their seems to be much more in word that i thought
Pete
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.