From: RayToddJr on
Which event do I need to use to be able to compare an .oldvalue vs .value?

I am currently using AfterUpdate event however, the .oldvalue is always
equal to the .value?

Thanks,

Ray.
From: Dirk Goldgar on
"RayToddJr" <RayToddJr(a)discussions.microsoft.com> wrote in message
news:F06E92C4-2403-4B37-BDC3-C78EB19CA741(a)microsoft.com...
> Which event do I need to use to be able to compare an .oldvalue vs .value?
>
> I am currently using AfterUpdate event however, the .oldvalue is always
> equal to the .value?


A bound control's .OldValue property holds the value of the control before
the record was modified. In the form's AfterUpdate event, the record has
been saved, so every control's .OldValue will be identical to its .Value.

In the form's BeforeUpdate event, or really any event that occurs after
Current and before AfterUpdate, the .OldValue may be different from the
..Value.

--
Dirk Goldgar, MS Access MVP
Access tips: www.datagnostics.com/tips.html

(please reply to the newsgroup)