What is form doing when says "Calculating" in bottom left

L

lbernarde

I have a form that is loading very slowly. It says calculating in the bottom
left hand corner. I'm looking to speed up the load. It takes about 20-30
seconds which is way too long. It is a form that has tab controls, many drop
down items and default data fields. Any suggestions would be greatly
appreciated.
Thank You
 
K

KLZA

I have a form that is loading very slowly.  It says calculating in the bottom
left hand corner.  I'm looking to speed up the load.  It takes about 20-30
seconds which is way too long.  It is a form that has tab controls, many drop
down items and default data fields.  Any suggestions would be greatly
appreciated.
Thank You

Try this:
Go to TOOLS > GENERAL TAB and make sure "Track Name Autocorrect info"
checkbox is not checked (ticked).
 
M

Marshall Barton

lbernarde said:
I have a form that is loading very slowly. It says calculating in the bottom
left hand corner. I'm looking to speed up the load. It takes about 20-30
seconds which is way too long. It is a form that has tab controls, many drop
down items and default data fields.


It is probably loading the recordsets for the subforms and
list/combo boxes. It would probably be a lot faster if the
record and row source queries used criteria to severly limit
the number of records that need to be retrieved.

If worse comes to worst, remove the record/row source and
only assign it the first time the controls get the focus.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top