Copy previous value in field on same form

[DonnaKK]

I know this has got to be easy! If one field is modified, I want to copy the before modified value into another field on the same form.

CurrentValueField = 2
PreviousValueField = 0

Now if CurrentValueField is modified to a 3, I want the 2 copied to the PreviousValueField.

CurrentValueField = 3
PreviousValueField = 2

 

[Crowley16]

put this in the onChange event of the field...

tbxNewField = currentField.value

note, use curField.Value and NOT .Text as .Value doesn't get changed till the current field has been confirmed

--------------------
Procrastinate Now!

 

[DonnaKK]

THANK YOU, CROWLEY16! Works like a charm! (Its always the simple things that get me!)