title: VBA: How to add entire row of recordset into form list
body: <p>I have Excel VBA code that runs a select query on an access database and returns a recordset. The connection works fine. When I get the recordset, I can access each field in each row fine. Here is what I am currently using:</p>
  
  <pre><code>Sub accessSelect(sql)
  Set rs = New ADODB.Recordset
  Call accessConnection
  
  With rs
      .Open sql, conn
  End With
  
  Do While Not rs.EOF
      'rtvEditForm.rtvList is a list box.
      rtvEditForm.rtvList.AddItem rs(1) &amp; " - " &amp; rs(2)
      rs.MoveNext
  Loop
  End Sub
  </code></pre>
  
  <p>I want to be able to throw the whole <code>rs</code> in the <code>rtvEditForm.rtvList</code> without having to refer to each field. I've tried <code>rtvEditForm.rtvList.AddItem rs</code>, but that does not work because I get a "Type Mismatch" error.</p>
  
  <p>Seems simple but I just can't figure this out. How would I do that with my current code?</p>