Link to home
Start Free TrialLog in
Avatar of PipMic
PipMicFlag for Gibraltar

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
ASKER CERTIFIED SOLUTION
Avatar of Gustav Brock
Gustav Brock
Flag of Denmark image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of PipMic

ASKER

Spot on...sorry for the delay
No problem. Thanks.

/gustav