I have an Access97 unbound form and would like to keep a history log of changes, time changed, old value, new value, date changed and by whom. I have a code but it only captures the value changed and not the old value.
Any help would be appreciated.

-- Placed in Before update of field txtModel
WriteAuditUpdate txtTableName, Me!txtSerialNumber, "Model", Me!txtModel.OldValue, Me!txtModel.Value