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?