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.

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.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"Beamers" <(E-Mail Removed)> wrote in message
news:771FAA9B-E0D1-4906-B162-(E-Mail Removed)...
> 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.