Change Event in DropDown List ComboBox

[Marrk R]

I have two ComboBoxes on a form. They are each Style 2 (DropDown List) because I need the user to select an existing choice in Combo1. Then based on the first choice, Combo2 will be filled with different data. The problem is, if I use Style 2, making a choice in the dropdown list does not fire the Change Event. This seems so simple, yet I have tried all of the logical events and none works the way I want it to. The LostFocus event on Combo1 will only update Combo2 if you move the focus off of Combo1 by clicking Combo2 or another control. Is there an easy way to do this so it immediately updates Combo2 when one of the choices in Combo1 is selected?

Also, if Combo2 is a DropDown List Style, I cannot seem to set which one of the options is the initial text in the ComboBox. It seems to only accept it if Combo2 is a DropDown Combo style that allows manual editing of the text, which I don't want.

Thanks for anyone's help.

[Marrk R]

Forget it I figured out that the Click event did the trick. I guess I assumed it would happen when I first clicked on the control. Geez... you work in circles all day on something, then figure it out just after posting a question to a forum. I knew it had to be simple and I was just missing it.

Setting the text in Combo2 seems to be working now too. Thanks anyway.