It sounds to me like you missed step 1 at "Enter the Form Events" (See bottom of page at http://allenbrowne.com/AppAudit.html)
The top of the form code page should have:
Code:
Option Compare Database 'you should always have these two lines at the top of every code page
Option Explicit
Dim bWasNewRecord As Boolean '<<must be here
Private Sub Form_BeforeUpdate(Cancel As Integer)
'Enters a user name in the EditedBy field
Me.[txtEditedBy] = CurrentUser()
'Inserts a timestamp for last edit whenever the record is modified
Me.[dtEditedDate] = Now()
bWasNewRecord = Me.NewRecord
Call AuditEditBegin("tbl_SFTP_Partners", "tbl_AudTemp_SFTP_Partners", "PartnerID", Nz(Me.PartnerID, 0), bWasNewRecord)
End Sub
'other code
Do you have the line in RED??