Form Saves too Slowly

S

Sammie

I have augmented my database and now an important form
takes forever to save and load. I took an order
application (like that in the Northwind DB) and changed all
the table, query, form and report names and also all the VB
Code I could find. It's not perfect yet, but it works.
The problem is that every time I make a design change to
the form, it takes about 2 minutes to save and return to
form view. What is the best approach to clean up this form?
Thanks. Sammie
 
D

Dirk Goldgar

Sammie said:
I have augmented my database and now an important form
takes forever to save and load. I took an order
application (like that in the Northwind DB) and changed all
the table, query, form and report names and also all the VB
Code I could find. It's not perfect yet, but it works.
The problem is that every time I make a design change to
the form, it takes about 2 minutes to save and return to
form view. What is the best approach to clean up this form?
Thanks. Sammie
Click to expand...

In my experience, this is usually the operation of the Name AutoCorrect
feature. Click Tools -> Options..., go to the General tab, and turn off
Name AutoCorrect. See if that makes a difference.
 
S

Sammie

Dirk said:
In my experience, this is usually the operation of the Name AutoCorrect
feature. Click Tools -> Options..., go to the General tab, and turn off
Name AutoCorrect. See if that makes a difference.
Click to expand...
That was exactly the problem! Makes a HUGE difference. Thanks.
 
Top