Greetings,
On my payment entry form, I've the following buttons: Add to input a new payment, and Edit, to make changes to existing payments. Lately, when users click Add, they receive run-time error '94' and clicking End will exit the database and create a _backup file, when they click Debug, the following is what they see
intSettleAmt = Forms!frmPICTSMain!frmFinancial!txtSettleAmt above is higligted in yellow
TIA,
Regards,
On my payment entry form, I've the following buttons: Add to input a new payment, and Edit, to make changes to existing payments. Lately, when users click Add, they receive run-time error '94' and clicking End will exit the database and create a _backup file, when they click Debug, the following is what they see
Private Sub txtCollectAMT_BeforeUpdate(Cancel As Integer)
'Add The Collected Payment
If IsNull(Me.txtCollectTot) = True Then
intCollectTot = Me.txtCollectAMT
End If
intSettleAmt = Forms!frmPICTSMain!frmFinancial!txtSettleAmt
If Forms!frmPICTSMain!frmFinancial!txtBalDue = 0 Then
MsgBox "Paid In Full " & intSettleame, vbInformation + vbOKOnly, "PAID IN FULL NOTICE"
Me.txtPaidInFull = "X"
Me.cmdCollectADD.Enabled = False
Me.cmdCollectEdit.Enabled = False
Me.cmdCollectSAV.Enabled = False
'Me.cmdCollectRpt.SetFocus
Cancel = True
Exit Sub
End If
intSettleAmt = Forms!frmPICTSMain!frmFinancial!txtSettleAmt above is higligted in yellow
TIA,
Regards,