I'm trying to update the following fields using SQL. The code used to work until I added the COMPLETE_FL part. When I run it, it returns with an error message "Syntax error (missing operator) in query expression "'[COMPLETE_FL]=-1'. I've tried different variations using the quotation marks but none seems to work. Your help would be appreciated. Thanks.
Code:
Dim strSQL As String
cboDSStatus.SetFocus
strSQL = "UPDATE tblN " & _
"SET [N_STATUS]=" & Chr(34) & Me.cboDSStatus.Text & Chr(34) & ", " & _
"[QCUSER]='" & xUserName & "' " & _
"[COMPLETE_FL]=" & Me.COMPLETE_FL.Value & " " & _
"WHERE [N_ID]=" & Me.N_ID.Value
DoCmd.RunSQL strSQL