Date Created or Date Modified Record Stamp

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to automatically generate a date create or date modified stamp
in the table.
 
At the table level, you are somewhat limited. For 'date created' you can add a field called DateCreated set to date/time datatype and a default value of
Date() (or Now() if you'd like the time recorded with the date). For the date modified though, you need to do this in a form (and also restrict users to modifying data only at the form level). Include the DateModified field in the recordsource for your form, and in the BeforeUpdate of the Form put the following:
Me!DateModified = Date()

(again you can use Now() instead if you want to include the time.
 
Back
Top