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

  • Thread starter Thread starter lbernarde
  • Start date Start date
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
 
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
Click to expand...

Try this:
Go to TOOLS > GENERAL TAB and make sure "Track Name Autocorrect info"
checkbox is not checked (ticked).
 
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.
Click to expand...


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.
 
Back
Top