>Hi all ---
>
>Many of y'all know this one but many more might not. I had forgotten it and it bit me in the butt with a client:
>
>When calling a Save routine from a Toolbar button or Menu option, the changed data in the current control may not be saved. Why? Because the Control never really loses focus and, therefore, the underlying ControlSource is not updated with the new Value.
>
>The trick is to force a LostFocus. A good way to do that is to SetFocus() to an OK button or other non-databound control in the same Form.
Exactly - I had to solve that one a while back. You can even have the control setfocus to itself, that's a little more generic way to do it...
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.