title: Run-time error '3061'. Too few parameters. Expected 1. (Access 2007)
body: <p>I have the following <code>'set recordset'</code> line that I cannot get working. The parameters seem correct according to all available help I can find on the subject.</p>
  
  <p>The error displays :</p>
  
  <blockquote>
    <p>"Run-time error '3061'. Too few parameters. Expected 1."</p>
  </blockquote>
  
  <p>Here is the line of code:</p>
  
  <pre><code>Set rs = dbs.OpenRecordset("SELECT Centre_X, Centre_Y FROM [qry_all_details] 
  WHERE ID = " &amp; siteID &amp; ";", dbOpenSnapshot)
  
  Where rs is the recordset (Dim rs As Recordset) and dbs = CurrentDb()
  </code></pre>
  
  <p>Any help would be appreciated.</p>
  
  <p>I have tried removing the <code>WHERE</code> cause with no effect, and also using single quotes between double quotes, but no joy.</p>
  
  <p>Many thanks.</p>