how to save Data value for each field entry on a bounded form

AccessHope

Registered User.
Local time
Today, 02:26
Joined
Jul 12, 2006
Messages
15
How to setup MS Access database to let the system automatically save Data value for each individual field entry on a bounded form?
I have a table call “Employee” with employee ID, Employee first name, and employee last name. Have a form bounded on this table. I want the data in the table instantly change/update once user edit/modify the data field on the form. I know database automatically save data record once move the insertion point to a different record. But I want the system to record each data value entered by user without move the whole record to next.
Is there configuration I can do in MS Access database or I have to write code to achieve this goal?

Many Thanks
 
did you try on AfterUpdate event of the control

DoCmd.RunCommand acCmdSaveRecord
 

Users who are viewing this thread

Back
Top Bottom