Which Form Event

  • Thread starter Thread starter RayToddJr
  • Start date Start date
R

RayToddJr

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.
 
RayToddJr said:
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?
Click to expand...


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.
 
Back
Top