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.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 & "'")