Having a problem with one of my forms taking *ages* to open. To fix it
I have to create a blank database and import everything. After doing
this, and setting up my references, everything works fine.

I can't tell why it starts doing it. I have quite a few forms, but it
only happens on one or two of my most complex ones. These are forms
with 3 tabs, lots of controls, and 3 - 5 subforms. I will be working
in a totally unrelated area and not know it has happened. When I go
do a little QA (this specific spot) I will discover that it has
cropped up again.

There isn't anything special happening on the one form that is a major
problem. The record source is set to "select * from query", where
query only returns one record. The subforms are linked, or have their
source set in the onOpen event.

When I trace the code I get the the DoCmd.OpenForm, then it just seems
to hang for a few minutes. The next place it lands me is in the
OnOpen event. I have no problem opening it in design mode, and every
other form in my db works just fine.

Can anyone suggest any possible fixes? I am up for just about
anything except a complete recode.

Thanks,
Andrew Backer



..---

Hi Andrew,

Have you turned off NameAutocorrect?
http://support.microsoft.com/?id=290181

Tom
_______________________________________

"Andrew Backer" <abacker_remove_Uspamerz (AT) comcast (DOT) dot.net> wrote


Having a problem with one of my forms taking *ages* to open. To fix it
I have to create a blank database and import everything. After doing
this, and setting up my references, everything works fine.

I can't tell why it starts doing it. I have quite a few forms, but it
only happens on one or two of my most complex ones. These are forms
with 3 tabs, lots of controls, and 3 - 5 subforms. I will be working
in a totally unrelated area and not know it has happened. When I go
do a little QA (this specific spot) I will discover that it has
cropped up again.

There isn't anything special happening on the one form that is a major
problem. The record source is set to "select * from query", where
query only returns one record. The subforms are linked, or have their
source set in the onOpen event.

When I trace the code I get the the DoCmd.OpenForm, then it just seems
to hang for a few minutes. The next place it lands me is in the
OnOpen event. I have no problem opening it in design mode, and every
other form in my db works just fine.

Can anyone suggest any possible fixes? I am up for just about
anything except a complete recode.

Thanks,
Andrew Backer



..---