Drop Down List Boxes

[Lochdanon]

Hi,

I'm hoping that someone can help. I have a Dropdown Box with different areas listed in my plant and another dropdown box that contains machine parts within it. The problem is that I want the first dropdown box to effect the second dropdown box.

For Example:

Dropdown box 1 -
GVL
DVL
LVL

Drop Down box 2 -
GVL Motor 1
GVL Motor 2 ....

Now if in Drop down box 1 I select GVL then only the motors for the GVL will appear in Dropdown box 2, but if I change to DVL then only the motors for the DVL will show. How can this be done?

Any help would be appreciated

Thanx

 

[soundsfishy]

There are plently sample available on this forum. Do a search on Cascading combo boxes.

Ive attached a sample for you as a starter.