.Value vs .OldValue

[George Too]

I was wondering what is the difference between .VALUE and .OLDVALUE. Can you guys explain in English?

 

[ColinEssex]

Value is the current value

OldValue is the last value

Col

 

[George Too]

So, if I want to get the corrent value from a text box the best property to use is Value instead of OldValue? How would OldValue, in this case, affect the outcome of my calculations?

 

[ColinEssex]

If the current value in a text box is 10 but it was 8 before -

The code Me.TextBoxName.Value will be 10

The code Me.TextBoxName.OldValue will be 8


Col

 

[Robert Dunstan]

Also the .OldValue is useful if you want to create an undo procedure

 

[George Too]

Reason I was asking is that I was using OldValue in my code but noticed that for some reason calculations were not right and there's where it came to me that it could be the property I was using.

Thanks for making it clear.
George