Date of Change

  • Thread starter Thread starter Stig
  • Start date Start date
S

Stig

Hi
Can I add a field to a table that shows when the record was last modified?
Thanks once again for all the help kind people have been giving on these
newsgroups.
Dave
 
Not unless you're using a form to update your data. If you are, put logic in
the form's BeforeUpdate event to set the LastModified date to Now.
 
Stig said:
Hi
Can I add a field to a table that shows when the record was last
modified? Thanks once again for all the help kind people have been
giving on these newsgroups.
Dave
Click to expand...

Add the field [RevisedOn] (for example) to the table and then in the form
used for editing use the BeforeUpdate event...

Me.RevisedOn = Now()

ALL edits must be done with a form that uses this code. You cannot enforce
this when editing the table directly.
 
Back
Top