Combo box affects values in another combo box

[damonrulz]

If I have two combo boxes (Combo1 & Combo2) and when a certain value in Combo1 is selected, the values in Combo2 that correspond with that value will show, and the rest will be hidden.

For example, if I wanted the values "1" and "2" in Combo1, and then "a", "b", "c", "x", "y", "z" in Combo2. When "1" is selected, "a", "b" & "c" will show. Then when "2" is selected, "x", "y" & "z" will show.

Any suggestions on how I might be able to achieve this?

[missinglinq]

The concept is called cascading comboboxes. Here's a link to a tutorial on the subject by Rabbit, one of our experts:

http://bytes.com/topic/access/insights/605958-cascading-combo-list-boxes

Linq ;0)>