Originally Posted by
cshort64
I want to keep history of a change on one field. I only need to keep the last change
Example I have two fields CurrentSerialNumber and OldSerialNumber. If a change is made to CurrentSerialNumber on the form I want to copy the value of CurrentSerialNumber prior to the change to OldSerialNumber.
I have added the following code to onclick and onupdate sections of CurrentSerialNum however on updating the CurrentSerialNum field OldSerialNum is updated to null. Any idea on what I am doing wrong.
Private Sub CurrentSeriealNum_AfterUpdate()
me.OldSerialNum.Value = mCurrentSerialNum
End Sub
Public Sub CurrentCalibratorSeal_Click()
Dim mCurrentSerialNum As String
mCurrentSerialNum = Me.CurrentSeriealNum
End Sub