title: syntax error in update statement run-time error 3144
body: <p>I got  syntax error in update statement.Run-time error: 3144 
   I use the following code</p>
  
  <pre><code>CurrentDb.Execute "UPDATE product " &amp; _
      " SET [product name] = '" &amp; Me.txtName &amp; "'" &amp; _
      ", [cost of product] = " &amp; Me.txtCost &amp; "" &amp; _
      ", [weight] = " &amp; Me.txtWeight &amp; "" &amp; _
      ", [group] = '" &amp; Me.CmbGroup &amp; "'" &amp; _
      ", [group ID] = '" &amp; Me.txtGroupID &amp; "'" &amp; _
      ", [Ordered] = " &amp; Me.txtOrdered &amp; "" &amp; _
      " WHERE [roduct name] = " &amp; Me.txtName.Tag &amp; ""
  </code></pre>
  
  <p>What can be the problem? 
  If it makes sense, then Me.txtCost , Me.txtWeight and me.txtOrdered are number</p>
  
  <p>Thanks for your help!</p>