Speed Issues on Form Open

[aggieval]

I am having speed issues when a form is opening. I believe my problem is that I have multiple sub-forms and combo boxes on the form. I believe that the form is querying every single combo box as it opens. Can anyone tell me if I am correct in my assumptions and how they have gotten around an issue like this.

Right now all the data is pullying by query behind the form. I am thinking that this should all be run using code, but would like any advice before I start anything.

Thanks in advance for any help.

Tracy

 

[KUZZ]

if you have a lot of graphix on the form...a recommendation would be to make all graphix not show at open. Graphix may be activated by clicking on something, later in the process.
That really helps. Also in access tools/options/general disable all name autocorrect related boxes...speeds up everything by at least 3x.

Good luck,
Kuzz

"Time spent debating the impossible subtracts from the time during which you
can try to accomplish it."

 

[AlienRay]

Combo boxes are probably not the problem, by the way, as they are not supposed to populate until they receive focus.