Hi, I am currently making a form which uses several data validations and activex controls. My problem is with 2 data validations (both are lists)... One is dependent on the other (the second data validation list changes according to what was selected from the first list)... I need the second data validation list to display nothing after changing the first so that no mistake is made and the second is left filled in according to whatever was selected from the first list previously.

Should I be using an activex control for this, and if so, how?

Thank you so much everyone!!!

-YeknomDude