How To Store Record Upddate Date and Time

[rockman]

My access database automatically opens to a user-input form that populates a table. How can access populate a new or edited record with the date and time the user updates the record using the form?

 

[LonnieJohnson]

In the form's BeforeUpdate event you should put a line of code that sends the current date and time to a text box. I am assuming you have a field in the record for this date. It would look like such:

Private Sub Form_BeforeUpdate ()

MyField = Now()

End Sub

Be sure that MyField is formated to store date and time in the format property of the field.

Hope this helps.