title: Runtime Error 3061 VBA using Insert command
body: <p>I have the following code.  I am using a form in MS Access 2010 to enter new lines into my table Nlog.  When I try to run the code, it gives me the error Run-Time error '3061': Too few parameters. Expected 1.  </p>
  
  <p>I can't find the error!</p>
  
  <pre><code>Private Sub Command128_Click()
      'add data to table
      CurrentDb.Execute "INSERT INTO NLog(IDKEY, Company, CoName, State, City, AmtpdTotal, DateRec, Notified, DateNotice, AcctID, TaxType, Period, NoticeReason, Resolution, TaxDue, Intdue, PenDue, Dateres, Amtpdint, amtpdpen, amtpdtax, Assigned, subAssgn, Resolved) " &amp; _
          " VALUES(" &amp; Me.TxtIDKEY &amp; ",'" &amp; Me.Company &amp; "','" &amp; Me.CoName &amp; "','" &amp; _
          Me.State &amp; "','" &amp; Me.City &amp; "','" &amp; Me.TxtAmtpdTotal &amp; "','" &amp; _
          Me.DateRec &amp; "','" &amp; Me.Notified &amp; "','" &amp; _
          Me.DateNotice &amp; "','" &amp; Me.AcctID &amp; "','" &amp; Me.TaxType &amp; "','" &amp; Me.Period &amp; "','" &amp; _
          Me.NoticeReason &amp; "','" &amp; Me.Resolution &amp; "','" &amp; Me.TaxDue &amp; "','" &amp; Me.IntDue &amp; "','" &amp; Me.PenDue &amp; "','" &amp; _
          Me.DateRes &amp; "','" &amp; Me.AmtPdInt &amp; "','" &amp; Me.AmtpdPen &amp; "','" &amp; Me.AmtpdTax &amp; "','" &amp; _
          Me.Assigned &amp; "','" &amp; Me.txtsubass &amp; "','" &amp; Me.Resolved &amp; "')", dbFailOnError 
  MsgBox ("Entry Added")
  </code></pre>