Date/Time Show When Changes Made

B

Beamers

Hi,

When changes are made in a table or form, I want the date and time to appear
showing me when changes were made in any of the fields.

How can it work?
MTIA.
 
D

Douglas J. Steele

It's not possible if you're working directly with tables.

Using foms, you have to put code into the form's BeforeUpdate event to
update the row's LastChanged field (which, of course, you have to add to the
table yourself)

You might find what Allen Browne has at
http://www.allenbrowne.com/AppAudit.html to be useful.
 
Top