Combo Box on a form 1

[RDS2]

I have two combo boxes on a form.
The underlying query which supports the list detail in the second combo box is based on a selection in the first combo box.
Everything works as it should for the first selection (first combo box) when I open the form.
When I change the selection in the first combo box though the selection choices are not updated to reflect the change. The second combo box selections are still based on the first selection when the form was opened. I've tried some code with the "On" events to no avail.
Any thoughts would be greatly appreciated.

 

[LaurieHamlin]

Have you tried putting the code in the After Update event of the first combo box?

 

[RDS2]

Thanks Laurie - works like a charm!