title: Access: Using query in VBA for recordset
body: <p>I have been accustomed to do recordssets in the following format:</p>
  
  <pre><code>Dim rs As DAO.Recordset
  Dim strSQL As String
  
  strSQL = "Select field1, field2 from myTable where field1 &gt; 30"
  
  Set rs = CurrentDb.OpenRecordset(strSQL)
  
  '... Do wahtever using rs.
  </code></pre>
  
  <p>Is it possible to use an already created query instead of text and giving it the where clause?</p>
  
  <p>This is a linked table to a SQL Server 2008 Database. I like to save simple queries in Access.</p>