ComboBox Select Case Question

I have two ComboBoxes. When a user selects an item in ComboBox1, the user can select a bunch of services in ComboBox2 specific to the item selected in ComboBox1. My code worked almost perfectly. Now here is the problem: when the user selects for example "steel tube" in ComboBox1, ComboBox2 will list a bunch of services specific to "steel tube". However, if the user then decided that he doesn't want the "steel tube" services instead he wants the "brass tube" services ComboBox2 will retain the services previously shown for "steel tube". If the user selects "steel tube" in ComboBox1 again, ComboBox2 will double the list of services for "steel tube" including the services in "brass tube". What I want is if the user select an item in ComboBox1 it will only show the services for the item selected.

Code:

Please Login or Register  to view this content.

Just add one line

Please Login or Register  to view this content.

Originally Posted by jindon

Just add one line

Please Login or Register  to view this content.

Oh My!Perfect Thanks! Solved!