Creating an audit trail of changes

[ChuckW]

Hi,

I am creating a table called SalesForecast. It has CustomerName, SalesRep,
Jan08, Feb08......Dec08. I am going to create an input form for sales reps
and they are going to put in monthly forecast dollars. I somehow want to
make it so that a sales rep can change a number but there is a record of a
change that takes place. so if Sales Rep A changes his May08 forecast from
$10,000 to $5,000, it would write this change to a table. Is there a way to
do this easily or are we talking massive VBA code?

Thanks,

 

[Allen Browne]

Access does not provide a built-in way to do this.

If the changes are made through a form, it is possible to use the events of
the form to track the edits, deletes, and inserts. Details here:
Audit Trail - Log changes at the record level
at:
http://allenbrowne.com/AppAudit.html