vb Code:
  1. If bStudentNumberExists Then
  2.             Using cmd As OleDbCommand = New OleDbCommand
  3.                 sSaveSql = "update CUSTOMER set " _
  4.                                & "Surname = ?," _
  5.                                & "Given = ?," _
  6.                                & "DateOfBirth = ?, " _
  7.                                & "Sex = ?," _
  8.                                & "Phone = ?," _
  9.                                & "Address = ?," _
  10.                                & "Suburb = ?," _
  11.                                & "State = ?," _
  12.                                & "PostCode = ?," _
  13.                                & "where ID = ?;"
  14.  
  15.                 cmd.Parameters.AddWithValue("@Surname", oThisFormA.txtCusSurname.Text.Trim)
  16.                 cmd.Parameters.AddWithValue("@Given", oThisFormA.txtCustGiven.Text.Trim)
  17.                 cmd.Parameters.AddWithValue("@DateOfBirth", CDate(oThisFormA.txtCustDOB.Text.Trim))
  18.                 cmd.Parameters.AddWithValue("@Sex", oThisFormA.txtCustSex.Text.Trim)
  19.                 cmd.Parameters.AddWithValue("@Phone", oThisFormA.txtCustPhone.Text.Trim)
  20.                 cmd.Parameters.AddWithValue("@Address", oThisFormA.txtCustAddress.Text.Trim)
  21.                 cmd.Parameters.AddWithValue("@Suburb", oThisFormA.txtCustSuburb.Text.Trim)
  22.                 cmd.Parameters.AddWithValue("@State", oThisFormA.txtCustState.Text.Trim)
  23.                 cmd.Parameters.AddWithValue("@PostCode", oThisFormA.txtCustPostCode.Text.Trim)
  24.                 cmd.Parameters.AddWithValue("@ID", CInt(oThisFormA.txtCustID.Text.Trim))
  25.  
  26.             End Using
  27.             'sSaveSql = "update CUSTOMER set " _
  28.             '             & "Surname = '" & oThisFormA.txtCusSurname.Text.Trim & "'," _
  29.             '             & "Given = '" & oThisFormA.txtCustGiven.Text.Trim & "'," _
  30.             '             & "DateOfBirth = '" & oThisFormA.txtCustDOB.Text.Trim & "', " _
  31.             '             & "Sex = '" & oThisFormA.txtCustSex.Text.Trim & "'," _
  32.             '             & "Phone = '" & oThisFormA.txtCustPhone.Text.Trim & "'," _
  33.             '             & "Address = '" & oThisFormA.txtCustAddress.Text.Trim & "'," _
  34.             '             & "Suburb = '" & oThisFormA.txtCustSuburb.Text.Trim & "'," _
  35.             '             & "State = '" & oThisFormA.txtCustState.Text.Trim & "'," _
  36.             '             & "PostCode = '" & oThisFormA.txtCustPostCode.Text.Trim & "'," _
  37.             '             & "where ID ='" & oThisFormA.txtCustID.Text.Trim & "';"
  38.  
  39.         Else
  40.             sSaveSql = "insert into CUSTOMER(ID, Surname, Given, DateOfBirth,Sex,Phone,Address,Suburb,State,PostCode) " _
  41.                      & " values('" & oThisFormA.txtCustID.Text & "'," _
  42.                      & "'" & oThisFormA.txtCusSurname.Text.Trim & "'," _
  43.                      & "'" & oThisFormA.txtCustGiven.Text.Trim & "'," _
  44.                      & "'" & oThisFormA.txtCustDOB.Text.Trim & "'," _
  45.                      & "'" & oThisFormA.txtCustSex.Text.Trim & "'," _
  46.                      & "'" & oThisFormA.txtCustPhone.Text.Trim & "'," _
  47.                      & "'" & oThisFormA.txtCustAddress.Text.Trim & "'," _
  48.                      & "'" & oThisFormA.txtCustSuburb.Text.Trim & "'," _
  49.                      & "'" & oThisFormA.txtCustState.Text.Trim & "'," _
  50.                      & "'" & oThisFormA.txtCustPostCode.Text.Trim & "' )"
  51.             MsgBox("ID:" & sCusID & " has been Added to the table")
  52.  
  53.  
  54.             ' Be careful however with the commas and the closing bracket
  55.         End If

With that as my Update code is still get SYNTAX ERROR in UPDATE clause

Thanks for your help so far, but still not working.