Audit trail for Unbound forms

[Luthius]

Guys
There are a couple of good examples in the internet on how to implement an audit trail database.
But unfortunetaly are examples for bound forms/controls.
I'm developing a database with unbound forms/controls.
I cannot use the property OldValue on unbound controls so I cannot implement the audit trail.

What is the best thing to do?
-Create a class modules with objects that can "clone" the values when the form is opened?
-Create arrays to collect the old values and then compare with values of each control when I trigger the Save button?

I really dont know what to do.
I cannot bound these forms/controls in my project.

Some Audit Trails examples (Bound forms)
https://hitechcoach.com/index.php/downloads-mainmenu-28/audit-trail
http://www.datawright.com.au/access_resources/tracking_data_changes_in_access.htm

 

[JonXL]

What will you be auditing?

 

[Luthius]

What will you be auditing?

The changes made on the records. This is very common on softwares.

 

[Micron]

You can probably use temp tables, bind the controls to the temp and use old value property and auditing code. Write record (update) back to main table IF the record is altered and flush the temp table on form close. I did play around with what I recall was a table/field level audit feature that I seem to recall was built in, but that was a while ago and not very impressive. I cannot recall how to turn it on.

Note
- I am not referring to continually creating/deleting any tables.
- deleting temp tables in a shared db is tricky - better that each user has their own fe (always preferred approach anyway) and the temps are local.