FAQ181-291: Transaction Log for Ms. Access creating duplicate records

[dotolee]

I'm using the code from FAQ181-291: Transaction Log for Ms. Access
It works fine for new records. But when I edit a previously saved db record, the field that's been updated is written out twice to the audit table.
it's not obvious to me why this is happening...

Thx.

 

[MichaelRed]

old value? new value?




MichaelRed

 

[dotolee]

The entire record is written out twice with the same date time stamp, oldval, newval, key name etc.

 

[dotolee]

I found the problem.
For some controls, i have a list box that is bound to a txt box on the same form...
Thank you for helping me out.