title: Access 2007 response time
body: <p>This database is linked to SQL tables. I used multiple queries to open duplicate forms because the different criteria.  Then I tried creating the search criteria with macros in the where condition.  Both ways are extremely slow.  </p>
  
  <p>Should this be handled through the "on Load" Even Procedure? With an If statement? to get the results of each query currently used.  </p>