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

A

Allen Browne

Use the BeforeUpdate event procedure of the form, e.g.:

Private Sub Form_BeforeUpdate(Cancel As Integer)
Me.[MyDateField] = Now()
End Sub
 

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

Get rid of Microsoft AutoUpdate 0
Copy previous record into form field 0
How do I clear a form? 0
Mail Merge skipping records/sending one at a time 0
problem entering dates excel 2003 0
Get the right language when inserting a date 2
Word doc keeps changing to ALL CAPS 0
Auto-Numbering in a Table in MS Word 1

Top