title: vba code not doing INSERT into database
body: <p>I am very new to access. I was told that the way to do a database insert in access is with the CurrentDb object (as long as the table is in the same database, and it is in my case.) I made this code, have no errors, but it doesn't do the insert.</p>
  
  <pre><code>Private Sub Add_Delete_Click()
  
  Dim query As String
  query = "Insert Into tbl_Inventory_History (InventoryID, Modification_Date, Change)"
  query = query &amp; "Values (" &amp; Me.InventoryID &amp; ",#" &amp; Now() &amp; "#," &amp; Me.Quantity &amp; ")"
  CurrentDb.Execute query
  End Sub
  </code></pre>
  
  <p>This code is run on a button click in the Inventory form page. I want it to insert any changes made to the inventory on the inventory history page. I made sure the the tbl_Inventory_History does exist and is spelled correctly. What is the issue?</p>