Record modification date information?
Quote:
>Hi,
>I'm trying to find out if Access stores a record's last
>modification date in its system tables so I can retrieve
>and display it in a form. Note that I'm using Access 97
>on some systems, so a solution must be compatible with
>that version. Can't seem to find this info anywhere...
No, there is no create or change date associated with a
record. If you want to have that kind of thing, then you
have to add a field to the table and set the value yourself.
This is easy to do in a data entry form using a single line
of code in the form's BeforeUpdate event procedure:
Me.DateModified = Now
--
Marsh
MVP [MS Access]
