title: Ms Access cannot get value from record set
body: <p>I'm working on an Access application (2007) in which there is an invocation of a stored procedure (SQL-Server 2012) which is supposed to return a simple result, a one column table with two records.</p>
  
  <p>When executing the procedure within the Server Management Studio, it shows a result as follows:</p>
  
  <pre><code>+----------------------------------------------------------+
  | One_Sticker                                              |
  +----------------------------------------------------------+
  | This is the first record of the result                   |
  | This is the second record of the result                  |
  | This is the third and last record of the result          |
  +----------------------------------------------------------+
  </code></pre>
  
  <p>In my Access code I have (Note: I know this is to be done within a loop, but the following is for debugging purposes only):</p>
  
  <pre><code>             Set RS = ADOCmd.Execute
  
  
               Set blabla = RS.NextRecordset      ' Get 1st record
       &lt;BP-1&gt;  Dummy_Variable = 1
  
               Set blabla = RS.NextRecordset      ' Get 2nd record
       &lt;BP-2&gt;  Dummy_Variable = 1
  
               Set blabla = RS.NextRecordset      ' Get 3rd record
       &lt;BP-3&gt;  Dummy_Variable = 1
  
               Set blabla = RS.NextRecordset      ' No more data.
       &lt;BP-4&gt;  Dummy_Variable = 1
  </code></pre>
  
  <p>[ means Breakpoint at this line]</p>
  
  <p>I'm running this with a watch at <code>blabla</code> to see what is being assigned to it every step.</p>
  
  <p>When looking at the watch on BPs 1, 2 and 3, <code>blabla</code> has a value while at BP 4 it is empty. This implies to me that the requred 3 records are indeed being returned.
  The problem is the the <code>Fields</code> entry within <code>blabla</code> has nothing (and hence <code>blabla.Fields("One_Sticker").Value</code> is unknown).
  How can i get the value of the One_Sticher field at blabla?
  What am I doing wrong?</p>
  
  <p>Thanks in advance for any useful suggestion.</p>