Saving a record on exiting Text box

DJ_DEF_CON_1

Registered User.
Local time
Today, 05:23
Joined
Jan 1, 2003
Messages
40
I have a form with a bunch of text boxes that are unbound. I have only one text box that is bound to a field in a table.

As the user enters their information into the form I would like to immediatley upon exiting of that bound text box to write that data into the field. I can only seem to get this record saved once they have gone through and entered information into the entire form.

I am new to Acess and I am sure there must be a way of saving this data immediatley upon exiting the text box.

Any help would be greatly appreciated.

Thanks
 
Put this in the After Update event of the bound text box...

DoCmd.RunCommand acCmdSaveRecord

HTH
 

Users who are viewing this thread

Back
Top Bottom