I've been trying to implement a simple Access audit log, using the excellent article by Dale Fry on this website. I can follow the logic and it does exactly what I'm looking to put in place but it falls over on a pretty fundamental point with my system/db.
The main sub checks the oldvalue property of each field to determine if the value has changed but I get a run-time error 437 (Object doesn't support this property or method). I have a straight-forward form linked to an MS-SQL table and the relevant code snippet is shown below - fails on line 3:
For Each fld In Form.RecordsetClone.Fields
If (Nz(Form(fld.Name).OldValue, "") <> Nz(Form(fld.Name).value, "")) Then
'field value has changed
bRecord = True
bRecord = False
Any ideas would be most welcome, I'm sure I'm missing something fundamental but currently at the brick wall stage! Is the oldvalue method just not possible with ms-sql table?