"Time stamp" Date/Time when Name Field populated

[Conner]

Have a form used to determine when an employee leaves the building. Similar to a time card. Has two textboxes -- one for LastName and the other CheckOutTime. When the employee enters Last name in LastName, I want CheckOutTime to automatically enter the date and time. Similar to what the Now( ) function does, but I don't want the date and time to change. Want it "frozen" at that moment...Can this be done?

 

[jrbarnett]

In the LastName's AfterUpdate event, put:

CheckOutTime = Now()
DoCmd.RunCommand acCmdSaveRecord

and ensure that the field is locked in design mode so it can't be changed by editing the field. This will update the field and save the data.

John

 

[Conner]

Worked like a charm! Sincere thanks for your quick response.