updating a field when the record is modified

  • Thread starter Thread starter David
  • Start date Start date
D

David

I have a form setup to launch a query and display with
edits enabled to modify fields in my main table. I have a
field titled MODIFIED in the table to track the time of
the most recent update. I was able to populate this field
when the entry is first created, how can I update the
MODIFIED field in this table when a record is modified?
Basically update the field with a now() command? My query
pulls up all records with my ID. It may pull back 50
records, If the user sees a row that needs to be modifed,
the user will click on the field and make the
corrections. On update or on exit, I want to be able to
change the field MODIFIED = now() for that one record.
 
In the form's BeforeUpdate event, use code similar to this:

Private Sub Form_BeforeUpdate(Cancel As Integer)
Me.[Modified].Value = Now()
End Sub
 
Back
Top