• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 174
  • Last Modified:

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
0
petePrinter
Asked:
petePrinter
  • 4
  • 3
1 Solution
 
GrahamSkanCommented:
Here is an example that uses 'Legacy' form fields.
FormsDropDowns.dot
0
 
GrahamSkanCommented:
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
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
petePrinterAuthor Commented:
Graham
Thank you
i missed you explanation first time sorry
0
 
GrahamSkanCommented:
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
 
GrahamSkanCommented:
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

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now