title: Use of CurrentDb.OpenRecordset in VBA
body: <p>I am editing something in VBA in MS access. Can someone please tell me the difference between below two statements.</p>
  
  <pre><code>1. Set rs1 = CurrentDb.OpenRecordset("tblOPCEPLTB")
  2. Set rs = CurrentDb.OpenRecordset("SELECT * FROM tblOPCEPLTB")
  </code></pre>
  
  <p>What I am guessing is 2nd line fetches all rows from table tblOPCEPLTB and store in rs variable. So what does 1st do? After executing 1st what should it have?</p>
  
  <p>Please help here</p>