Changes to form causes slow opening

[M Skabialka]

I have a form which opens very quickly, unless I make any changes to it.
Then it takes 10 - 15 seconds to open. Even such a small change as moving
the field around. I tried making a blank new form, copying the fields and
VBA code and this form will also be slow to open. I have decompiled and
recompiled the databases (FE/BE) more than once. The fields all come from
one table, a combo to select the current record, a couple of combos drawing
from very small tables to validate entry data, and 3 buttons to open other
forms.

What might be the problem here? Other forms and reports in this Access 2000
database work fine.

Thanks,
Mich

 

[Allen Browne]

Make sure the Name AutoCorrect boxes are unchecked under:
Tools | Options | General
Explanation of why:
http://allenbrowne.com/bug-03.html

If the tables are attached, make sure the SubdatasheetName property is set
to [None]. More about that and other issues:
http://www.granite.ab.ca/access/performancefaq.htm

 

[M Skabialka]

The first option speeded it up a little, the second made it open
immediately!

Thanks so much!
Mich

Make sure the Name AutoCorrect boxes are unchecked under:
Tools | Options | General
Explanation of why:
http://allenbrowne.com/bug-03.html

If the tables are attached, make sure the SubdatasheetName property is set
to [None]. More about that and other issues:
http://www.granite.ab.ca/access/performancefaq.htm

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

I have a form which opens very quickly, unless I make any changes to it.
Then it takes 10 - 15 seconds to open. Even such a small change as moving
the field around. I tried making a blank new form, copying the fields and
VBA code and this form will also be slow to open. I have decompiled and
recompiled the databases (FE/BE) more than once. The fields all come from
one table, a combo to select the current record, a couple of combos
drawing from very small tables to validate entry data, and 3 buttons to
open other forms.

What might be the problem here? Other forms and reports in this Access
2000 database work fine.

Thanks,
Mich