I created a module and added thew code below. (got it from one of the MVP's)
I had to create a table named "audit" with the following fields
EditRecordId autonumber
editdate date/time
User short text
recordid number
sourcedata short text
sourcefield short text...