Record Updated Field

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
 
A

Allen Browne

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.
 
Top