title: VBA Access: No value given for one or more required parameters
body: <p>I know, there are lots of answers out there for this problem which should be trivial, but I did not find the right one. Here is my problem:
  I open a record set with the following select statement: </p>
  
  <pre><code>SELECT twinecellar.produktnavn, twinecellar.land, 
   twinecellar.produkttype,  twinecellar.år, 
   twinecellar.antall, twinecellar.poeng, 
   twinecellar.Picture, twinecellar.KR, 
   twinecellar.Poengsum, twinecellar.Sum
  FROM twinecellar
  WHERE (((twinecellar.land)=forms!fmainview!list13) 
    And ((twinecellar.produkttype)=forms!fmainview!list15))
  ORDER BY twinecellar.poeng;
  </code></pre>
  
  <p>In the immidiate window I see that list 13 contains "france" and list 15 contains "red"
  When I create a new Query with this statement, it's working, however, on the rst.Open gsStrQuery I get this error. gsStrQuery contains the select string.</p>
  
  <p>Here is the code:</p>
  
  <pre><code>Dim conn As ADODB.Connection
  Dim rst As ADODB.Recordset
  
  Set conn = CurrentProject.Connection
  Set rst = New ADODB.Recordset
  
  rst.CursorType = adOpenDynamic
  rst.ActiveConnection = conn
  rst.Open gsStrQuery
  </code></pre>
  
  <p>Anybody out there with a good idea about this issue?</p>