Get old value before the new value is entered

[H1004]

If I want to capture an old value before it gets update. How can I go about
doing that..I tried assigning the value before the form update, but it doesn't work.
For example:
Private Sub Form_BeforeUpdate(Cancel As Integer)
Me.txtOldPoints = Me.fraContactResult.Value
End Sub
And I even try
Private Sub fraContactResult_BeforeUpdate(Cancel As Integer)
Me.txtOldPoints = Me.fraContactResult.Value
End Sub
But it doesn't work either.
Any suggestion to do this.

 

[RoyVidar]

Hi!

Have you tried using the .OldValue property of the control? I'm not sure if it's available in access 97, though.

[tt]Me!txtOldPoints.Value = Me!fraContactResult.OldValue[/tt]

Roy-Vidar