RowSource of Combo Dependent another Combo

[Stu]

I have a form with ComboBox1 and ComboBox2. When in Add mode, whatever the
user selects in ComboBox1 changes the SQL rowsource of Box2 using an
AfterUpdate event on Box1. Works fine. But if the form is in Edit mode
suppose the user only wants to change a value in Box2. How do I ensure the
rowsource in Box2 is correct based on the value in Box1 that hasn't changed?
I'm looking for an event, maybe some psuedo code.

 

[Douglas J. Steele]

The Current event fires each time the active row changes. Put your code in
there.

 

[Douglas J. Steele]

Just in case it isn't clear, that's the Current event of the form.