title: SQL query in access vba
body: <p>I have problem with this UPDATE query , I have got message about syntax error query. I think that this query is correct and I can't find what is giving this error.</p>
  
  <p><a href="http://imageshack.us/a/img829/5702/29ta.png" rel="nofollow">Link to error</a></p>
  
  <pre><code>Private Sub cmdModifyBook_Click() 'approves modifying books to the database
  
  Dim str As String
  Dim dbs As DAO.Database
  
  Set dbs = CurrentDb()
  
  'checks if the typed all the data of book
  If (Me.txtModifyTitle.Value = "") Or (Me.txtModifyTitleWeb.Value = "") Or (Me.txtModifyVerkaufpreis.Value = "") _
     Or (Me.txtModifyThemengruppe.Value = "") Then
     MsgBox "Nicht alle von Ihnen eingegebenen Daten"
     Exit Sub
  End If
  
  str = " UPDATE Katalog " _
      &amp; "(Bezeichnung, BezeichnungWeb, Verkaufspreis, Themengruppe) SET " _
      &amp; "('" &amp; Me.txtModifyTitle.Value &amp; "', '" &amp; Me.txtModifyTitleWeb.Value &amp; "', '" &amp; Me.txtModifyVerkaufpreis.Value &amp; "', '" &amp; Me.txtModifyThemengruppe.Value &amp; "') WHERE ID_Buch =" &amp; Me.lblModifyID.Caption &amp; ";"
  
  dbs.Execute str, dbFailOnError
  
  MsgBox "Das Buch wurde in der Datenbank geändert", vbInformation
  
  dbs.Close
  Set dbs = Nothing
  
  End Sub
  </code></pre>