VBA - Controlling User Input

[Gorganzola]

So, I built a form that actually works pretty much as expected and desired except for one tiny little niggle. I had to learn VBA to push it to this point, prior to that I was able to rely solely on the functionality within Word for controlling the form.

The only problem is that the drop-down control requires me to tab out of it or select another control that has the macro associated with it, that does the calculation. If I modify the drop-down, then click to another field in the form that doesn't have the VBA associated with it, then it won't make the necessary changes that I need.

Basically, if I click outside the drop-down control, the On Exit event isn't firing unless I click another control associated with the VBA. Tabbing out of the control will have the On Exit event fire. But we all know how users will behave.

Any ideas on how to control this? Thanks.