A combobox starts out with controlsource empty. We want to force user to either make a choice, press escape, or press the cancel button. Since the valid event does not fire if user clicks on onother control we are trying to place code in LostFocus but haven't been able to figure out what works.

Any ideas? TIA,

Alex