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

[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

 

[Allen Browne]

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