Two combo boxes

[prmitchell]

I have two combo boxes on a switchboard where the second is based on the user's selected value in the first box. The values in the second combo box are determined from a query which gets the selected value from the first combo box.
This works fine from scratch but how do I refresh the values in the second if the user changes their mind on the selected value in the first?

 

[John Big Booty]

In the On Change event of the first Combo put the following code;

Me.SecondComboName.Requery

 

[prmitchell]

thank you kindly