Hey All,

Need some help resolving a Syntax error as title says, been a long day pretty sure it's a simple fix but i can't find the error.

Code:
If bStudentNumberExists Then


            sSaveSql = "update CUSTOMER set " _
            & "Surname = '" & oThisFormA.txtCusSurname.Text.Trim & "'," _
            & "Given = '" & oThisFormA.txtCustGiven.Text.Trim & "'," _
            & "DateOfBirth = '" & oThisFormA.txtCustDOB.Text.Trim & "', " _
            & "Sex = '" & oThisFormA.txtCustSex.Text.Trim & "'," _
            & "Phone = '" & oThisFormA.txtCustPhone.Text.Trim & "'," _
            & "Address = '" & oThisFormA.txtCustAddress.Text.Trim & "'," _
            & "Suburb = '" & oThisFormA.txtCustSuburb.Text.Trim & "'," _
            & "State = '" & oThisFormA.txtCustState.Text.Trim & "'," _
            & "PostCode = '" & oThisFormA.txtCustPostCode.Text.Trim & "'," _
            & "where ID ='" & oThisFormA.txtCustID.Text.Trim & "';"


        End If