title: MS ACCESS 2007 VBA : DAO recordset....how can I view all the "fields" in the returned collection
body: <p>so if i do a SQL statement like so:</p>
  
  <pre><code>sql = "SELECT * FROM tblMain"
  
       set rs = currentdb.openrecordset(sql)
  </code></pre>
  
  <p>what method can i use to view every "field name" in this collection i have just created. i am getting some very strange error stating that the item is not found in this collection.</p>
  
  <p>i know the field exists in the table, i have triple checked the spelling everywhere when i reference it, and the SQL should be pulling everything, but i want to see it.</p>
  
  <p>is there a debug.print method to see all these fields</p>
  
  <p>thanks
  Justin</p>