Record Updated Field

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

I need to create a query extracting all records in a table
which have been updated - does anyone know what Microsoft
Access field shows the date the record was last updated?

Many Thanks
 
Access does not provide this to you.

Provided your entries are always made through a form, you can create your
own date/time field, and use the BeforeUpdate event of the form to record
the system date of the most recent update:
Private Sub Form_BeforeUpdate(Cancel As Integer)
Me.[NameOfYourDateTimeFieldHere] = Now()
End Sub

Then it is easy to create a query to filter those records.
 
Back
Top