Hello,
I have a Function auditTrail(myform As Form) in a module name m_software
and
Private Sub Form_BeforeUpdate(Cancel As Integer)
Dim saveAns As Integer
saveAns = MsgBox("Do you want to save changes?", vbYesNo)
If saveAns = vbYes Then
DoCmd.Save acForm, "f_asset"...