title: Ms Access VBA run select query without opening
body: <p>Is there any way to run a query using VBA without is opening? Currently the code I'm using is:</p>
  
  <pre><code>DoCmd.OpenQuery "qryAvailableCarpenters" 'Sorts the carpenters according to their jobs
  DoCmd.Close acQuery, "qryAvailableCarpenters"
  DoCmd.OpenQuery "qryPermanentCarpenters" 'Sorts the supervising carpenters according to their number of supervisions
  DoCmd.Close acQuery, "qryPermanentCarpenters"
  DoCmd.RefreshRecord 'Enables the changes in sorting to be reflected in the combo box
  </code></pre>
  
  <p>This works but you still see a flash of the queries opening then closing. Is there a way I can change that?</p>