OnDirty and OnDelete Backup

[agibson]

I would like to back up my data when someone modify's a record in a form so that the whole old record would go to a new table that I could look at and see if someone messed something up could Someone please advise??

 

[pbaldy]

Welcome to the site. You might try searching here on "audit" or "audit trail", which should turn up methods to track changes to data.

 

[irish634]

I agree with pbaldy. Do a search for Audit Trail. There are many excellent examples on here. I put mine in the "Code Repository" section.

 

[HiTechCoach]

I would like to back up my data when someone modify's a record in a form so that the whole old record would go to a new table that I could look at and see if someone messed something up could Someone please advise??

I would like to add:

I would not use the On Dirty event, but the Before update event to log the changes.

About deleting, I prefer to use a field as a delete flag and not actually delete the record. The flag can be used to filter the records so that it appears to the users as deleted, but it really is not.