Vba adding data to table overwrites other data
<p>I made a database for work, and made a form to add stuff to it, so the workers don't mess with the tables. It will always add the data, but sometimes instead of adding it to the bottom, it will overwrite another row of data. Sometimes not even an entire row, just a couple of the columns.
I've tried to do the code in two different ways.</p>

<pre><code>    CurrentDb.Execute " INSERT INTO [Service Calls] " _
    &amp; "([Project Name], [Phone Number], [email], [Source], [Service Address], [Zip Code], [Date of Service], [Type of Call], [Technician], [Ticket Number], [Invoice Number], [Total Billed], [Description of Work]) VALUES " _
    &amp; "('" &amp; Me.proj &amp; "', '" &amp; Me.phone &amp; "', '" &amp; Me.email &amp; "', '" &amp; Me.source &amp; "', '" &amp; Me.address &amp; "', '" &amp; Me.zip &amp; "', '" &amp; Me.doS &amp; "', '" &amp; Me.toC &amp; "', '" &amp; Me.tech &amp; "', '" &amp; Me.ticketNum &amp; "', '" &amp; Me.invoiceNum &amp; "', '" &amp; Me.billed &amp; "', '" &amp; Me.work &amp; "');"
    CurrentDb.Close
</code></pre>

<p>and</p>

<pre><code>Dim rst As Recordset
Set rst = CurrentDb.OpenRecordset("Service Calls")
With rst
 .AddNew
 .Fields("Project Name") = Me.proj
 .Fields("Service Address") = Me.address
 .Fields("Date of Service") = Me.doS
 .Fields("Technician") = Me.tech
 .Fields("Total Billed") = Me.billed
 .Fields("Zip Code") = Me.zip
 .Fields("Description of Work") = Me.work
 .Fields("Type of Call") = Me.toC
 .Fields("Invoice Number") = Me.invoiceNum
 .Fields("Ticket Number") = Me.ticketNum
 .Update
 End With
  rst.Close
  Set rst = Nothing
</code></pre>

<p>I am that one contains more data than the other. I used the top code when I updated the form.</p>

<p>Solved: Some fields in the form were bound. So, those items would occasionally overwrite. Once I unbound those fields, it would stop overwriting. </p>