I have spent some time developing an audit trail.
Any change to a table will be recorded.
The audit trail actually ended up looking like the one that can be found on the Microsoft website. However, I developed my own and understand it!
All was working well until I transferred the audit code into a "Module".
It is now crashing. (For Each ccont In Myform.Controls).
I don't know why ??
(It is probably fairly fundamental as I am not very experienced).
To demonstrate look at this simple database and amend and save a record in form1.