Date of Change

[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

 

[Douglas J. Steele]

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.

 

[Rick Brandt]

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

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.

 

[Stig]

Thanks for the help