D
DS
I have this SQL Statement that keeps giving me the Error...
Function or variable expect...any help appreciated.
Thanks
DS
Dim MORESQL As String
DoCmd.SetWarnings False
MORESQL = "UPDATE tblChecks SET tblChecks.ChkPaid = -1 " & _
"WHERE tblChecks.CheckID = Forms!frmCheckPayment!TxtSalesID " & _
DoCmd.RunSQL(MORESQL)
DoCmd.SetWarnings True
Function or variable expect...any help appreciated.
Thanks
DS
Dim MORESQL As String
DoCmd.SetWarnings False
MORESQL = "UPDATE tblChecks SET tblChecks.ChkPaid = -1 " & _
"WHERE tblChecks.CheckID = Forms!frmCheckPayment!TxtSalesID " & _
DoCmd.RunSQL(MORESQL)
DoCmd.SetWarnings True