Speed first use of combo by running query at form load?

  • Thread starter Thread starter Leonard Priestley
  • Start date Start date
L

Leonard Priestley

I notice that when I first open a form and use a combo box to find a record
there is a bit of a delay. After the first time the combo box is used the
delay is not noticeable. I assume the initial delay is caused by a query
running and I wonder how to do that when the form loads, so it is not so
obvious. Any ideas anyone?

Chloe
 
The delay could result from uncompiled code.
Press Ctrl+G to open the Immediate window.
Choose Compile from the Debug menu.

If that doesn't solve the problem, you could probably force Access to load
the combo by including this line in the Form_Load event procedure:
Me.[MyCombo].Requery
 
Back
Top