Monitoring Data Change

[sahersite]

I have designed a table, which have user name, machine name, current date, time and event description
The first three doesn’t have a problem as they can be retrieved by

Environ(“username”)
Environ(“computername”)
Date()

But my problem is in the last one; Event Description
What I want to do is monitoring the changes (update, delete) on the data which already exist on each field. In another words, logging any alters or changes on any field.
So, what code should I write to perform that?

Thanks in advance,

 

[ColinEssex]

If you search for "Audit Trail" you will find everything you need to monitor changes.

Col