Try adding the following code:
THISFORM.ActiveControl.SetFocus() && Ensures last ActiveControl's ControlSource is updated.
Depending on how your users use this form will decide where you will need this. For example, if they open the form, type in the editbox and then just close the form you could try placing the code in the forms .QueryUnload Event. HTH
>In my app. I allow the user to append a dbf with a memo field through a form in an edit box. The form calls the dbf so the append is directly on the memo field. If the user does not tab out of the field the appended information is not saved. Is there a method to save the entry into the memo field without the user hitting the tab key or creating a save button.
>
>Thanks for any help!
>
>Pat
Colin Magee
Team Leader, Systems Development
Metroland Media Group Ltd.
Mississauga, Ontario, Canada
cmagee@metroland.comNever mistake having a career with having a life.