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?
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.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.