Hi experts.. I'm getting the above error when trying to update may database table with the code below.

Is my understanding correct that the code below is instructing access to update the stated database ""Update R_P_Data_P" by setting the listed fields to the values of the me.XXX values listed but only for the record where the field rID is = me.txtrID??

Background - I ask because it's the addition of this field and criteria that Has started giving me this error. The rID field in the table is an autonumber field. The me.txtrID field is a number format unbound field on the subform.

CurrentDb.Execute "Update R_P_Data_P " & _
"Set refNo='" & Me.txtrefNo & "'" & _
", ProfileCriteria='" & Me.cmbpc & "'" & _
", subProfileCriteria='" & Me.cmbsubpc & "'" & _
", appNo='" & Me.txtappno & "'" & _
", DetailsSummary='" & Me.txtdetsum & "'" & _
", actionDetails='" & Me.txtactiondet & "'" & _
", outcome='" & Me.cmbOut & "'" & _
", deadlineDate=#" & Me.txtDeaddate & "#" & _
", createdBy='" & Me.cmbcreatedby & "'" & _
", dateCreated=#" & Me.txtDatecreated & "#" & _
", qtr='" & Me.txtQtr & "'" & _
", activity='" & Me.cmbActi & "'" & _
", dateAssessed=#" & Me.txtDateAss & "#" & _
", assignee='" & Me.txtassignee & "'" & _
", responseDetails='" & Me.txtrespdet & "'" & _
", responseDate=#" & Me.txtRespdate & "#" & _
", status='" & Me.cmbstatus & "'" & _
", score='" & Me.txtscore & "'" & _
", colour='" & Me.txtColour & "'" & _
" WHERE rID='" & Me.txtrID & "';"

I'm slowly loosing the will to code because I'm absolutely frustrated now as I just can't understand why is not working. Please Please help