well i here is what i have on the form that the data is typed in:
Private Sub Form_BeforeUpdate(Cancel As Integer)
bWasNewRecord = Me.NewRecord
Call AuditEditBegin("EmpInfo", "audTmpEmpInfo", "ID", Nz(Me.ID, 0), bWasNewRecord)
If Not IsNull(Me.SSN) Then
Call Enc("Me.SSN")
End If
End Sub...