vba .OldValue not working

[spinkung]

hi

i'm trying to use old value on an after update event so i can create an audit of changes.

However, the value i'm getting is always the new changed value. do i need to get the value in another event? the control is a bound field to an sql table.

thanks

:banghead:

 

[JHB]

Not tested - but what about before update event?

 

[CJ_London]

oldvalue is set to newvalue when the record is updated, so you need to capture it in the before update event.