PipMic
asked on
Runtime error 3144
Hi,
I have the following code which is assigned to as event procedure on a form button. I am using A97
I am getting the following error message:
Runtime error '3144';
Syntax error in UPDATE statement
Grateful if some one assist me as to why this is occurring.....
Case "Cancel Import"
'Delete Import Import Side
DoCmd.SetWarnings False
DoCmd.RunSQL ("Update tblImportedErrors Set Delete = True, RequestedUserID = " & GetUserID & ", RequestedUserGrade = " & GetUserCurrentGrade & ", RequestedDate = #" & Format(Now(), "mm/dd/yyyy") & "# , Action = 'Pending',RequestedAction = ' " & btnActionTwo.Caption & "' WHERE f2 = '" & Me.f2 & "'")
DoCmd.SetWarnings True
I have the following code which is assigned to as event procedure on a form button. I am using A97
I am getting the following error message:
Runtime error '3144';
Syntax error in UPDATE statement
Grateful if some one assist me as to why this is occurring.....
Case "Cancel Import"
'Delete Import Import Side
DoCmd.SetWarnings False
DoCmd.RunSQL ("Update tblImportedErrors Set Delete = True, RequestedUserID = " & GetUserID & ", RequestedUserGrade = " & GetUserCurrentGrade & ", RequestedDate = #" & Format(Now(), "mm/dd/yyyy") & "# , Action = 'Pending',RequestedAction = ' " & btnActionTwo.Caption & "' WHERE f2 = '" & Me.f2 & "'")
DoCmd.SetWarnings True
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
No problem. Thanks.
/gustav
/gustav
ASKER