Receiving run-time error '3144' syntax error in update statement

[Chaddaman]

I have created a database using macros and I am recieving the above run-time error. The debugger is displaying the following code as the culpret:

Private Sub Form_Current()
DoCmd.SetWarnings (False)
DoCmd.RunSQL "UPDATE tbl_Current_Record SET tbl_Current_Record.Current_Rec_CWS_Num = " & [Form_frm_Suspended Well Management].CWS__ & " WHERE tbl_Current_Record.ID=1;"
DoCmd.SetWarnings (True)
End Sub

The error appears when the user advances through the last record for a particular query or when the add record button is pressed on the form. The error message says it is a syntax error however the code was generated by access...any ideas to what may be the problem.

 

[CajunCenturion]

The problem may be in the value of [Form_frm_Suspended Well Management].CWS_ especially if it is Null or is a null string, or contains a non-numeric value.

Good Luck
--------------
As a circle of light increases so does the circumference of darkness around it. - Albert Einstein