How do I autoupdate a date on a form when a record changes?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I update a date in a text field automatically whenever a record is
changed?
 
Use the BeforeUpdate event procedure of the form, e.g.:

Private Sub Form_BeforeUpdate(Cancel As Integer)
Me.[MyDateField] = Now()
End Sub
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Last update on.. 1
Automatically update a text field when any entry changed 3
Need combo box to refresh when moving to new record 2017 1
Showing Date Stamp on Form 6
Access How to record date/time when specific field is modified in Access 2007 0
Date fields on a form 2
"Date updated" in "one" record any time a "many record" changes? 8
Create A Search Field on a Form 2

Back
Top