title: access vba update one table, multiple fields
body: <p>Help, i want to update my table <em>PARKING</em> with the field <em>PARKING_STATUS</em> value <em>UPDATED</em> but I got error. I fetch everything from the same table. All fields at the form are from the same table <em>PARKING</em>, with PK and FK with other table. This is the code:</p>
  
  <pre class="lang-vb prettyprint-override"><code>Private Sub Approve_Btn_Click()
  
      'update data into table(s)
       CurrentDb.Execute "UPDATE PARKING" 
      "SET(parking_id= '" &amp; Me.lot_num_dropdown &amp; "', parking_status = '" &amp; "UPDATED" &amp; "', car_reg_num = '" &amp;    Me.car_reg_num_dropdown &amp; "', result_id = '" &amp; Me.result_id_dropdown &amp; "')" &amp; _
      "WHERE parking_id = '" &amp; Me.lot_num_dropdown &amp; "'"
  
  End Sub
  </code></pre>