Im working on a project for college. The form im working on allows the user to edit the details of a customer. I have the following code attached to the EDIT button
EditCustomerTable.Clear()
EditCustomerConnection.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=QuickQuotes.mdb"
EditCustomerConnection.Open()
EditCustomerAdapter = New OleDb.OleDbDataAdapter
Dim SQL As String = "UPDATE Customers SET [First Name] = '" & txtCustomerFirstName.Text & "'," _
& "[Last Name] = '" & txtCustomerLastName.Text & "'," _
& "[Street] = '" & txtCustomerStreet.Text & "'," _
& "[City] = '" & txtCustomerCity.Text & "'," _
& "[County] '" & txtCustomerCounty.Text & "'," _
& "[Postcode] = '" & txtCustomerPostcode.Text & "'," _
& "[E-mail] = '" & txtCustomerEmailAdd.Text & "' " _
& "[PhoneNumber] '" & txtCustomerTele.Text & "'," _
& "WHERE ID = " & txtCustomerID.Text & ""
EditCustomerAdapter = New OleDb.OleDbDataAdapter(SQL, EditCustomerConnection)
CommandBuilder = New OleDb.OleDbCommandBuilder(EditCustomerAdapter)
EditCustomerAdapter.Fill(EditCustomerTable)
EditCustomerConnection.Close()
but when i click the button the program crashes and says that there is a Syntax error in the UPDATE statement. I cant seem to find any errors. I was wondering if someone could help please.