Changing so deleting of fields (to null) is recorded | Message 35 of 54 | TechRepublic

Discussion on:

A simple solution for tracking changes to Access data

View entire thread

Message 35 of 54

Next » « Prev

0 Votes

+ -

Changing so deleting of fields (to null) is recorded

Change your if statement from: If .Value .OldValue then

To: If (.Value .OldValue) Or (Not IsNull(.OldValue) And IsNull(.Value)) Then

Posted by waltjr50

23rd Mar 2010