title: MS Access: Pre-loading data from backend
body: <p><strong>Summary</strong></p>
  
  <p>I have various forms in an Access front end database with several drop-down lists. These populate from queries, which take data from tables in a back end Access database (via linked tables).</p>
  
  <p>On opening the front end and clicking the first drop-down combo box, there is a wait of several seconds (often accompanied by a "Not responding" message) while the table data from the back end (on a server) is downloaded.</p>
  
  <p>It strikes me that this loading could be initiated as soon as the front end opens, and before the user clicks the first combo box. Is there any way to pre-load the table -- preferably with no "not responding" message?</p>