title: ms-access: how to do a proper requery?
body: <p>i am distributing ms-access-2007 front ends. the back end is sql server. a user will click on a button and it will return a query from the sql server 2008 database. </p>
  
  <p>is it possible to requery this query if the user clicks the button again?</p>
  
  <p>usually the behavior of access is that if you query it again, it displays old results. how do i make it refresh results?</p>