Run Time error 3061 Too Few parameters. Expected 6. Unable to update table from listbox
<p>All,</p>

<p>I am running the below SQL and I keep getting error 3061. Thank you all for the wonderful help! I've been trying to teach myself and I am 10 days in and oh my I am in for a treat!</p>

<pre><code>Private Sub b_Update_Click()
Dim db As DAO.Database
Set db = CurrentDb

strSQL = "UPDATE Main" _
       &amp; " SET t_Name = Me.txt_Name, t_Date = Me.txt_Date, t_ContactID = Me.txt_Contact, t_Score = Me.txt_Score, t_Comments = Me.txt_Comments" _
       &amp; " WHERE RecordID = Me.lbl_RecordID.Caption"
       CurrentDb.Execute strSQL
</code></pre>