You can use the lost focus event. This event fires any time you leave the
combo box.
--
HTH...

Jim Thomlinson


"Squeaky" wrote:

I need to be able to refresh a second combo box (from the Control Toolbox)
based on the selection of the first combo box. I have seen many posts that
say to Code an AFTER UPDATE event for combo1 with a requery:
Me!Combo2.Requery
Where do I find this AFTER UPDATE? I am using Excel 2000
It is not listed in the declarations in VBA. I am not strong in VBA, just
getting started.

Thanks,

Squeaky