Calculating... In a form with subforms

[Guest]

When moving from one record to the next, I receive a delay of approximately
30-45 seconds when the program goes into a "Calculating..." status.

The form contains a master form with three two subforms one of which has its
own subform.

The data it is returning is accurate, it just takes quite a bit of time to
go through the records.

In some cases it actually runs a query. This must be when opening the
tables as none of the forms are based on a query.

Any help is streamlining would be appreciated.

 

[Allen Browne]

Lots of things could contribute to this. Unless the form is doing some
particluarly complex operations, it should be possible to move records in a
fraction of a second.

For starters, work through the issues Tony Toews describes in his:
Access Performance FAQ
at:
http://www.granite.ab.ca/access/performancefaq.htm
Particularly, start with Name AutoCorrect and Subdatasheet name.

If you have anything in the Current event procedure of the forms,
temporarily comment out that code.

If you have calculated controls or conditional formatting, temporarily
remove those.

If any of the forms rely on a query, with calculated fields, you could try
temporarily removing those. Particularly any that use the domain aggregate
functions such as DLookup().

For any fields that are sorted or have criteria, open the table in design
view, and make sure the field is indexed.

The forms should now be flying, and along the way you will have identified
the bottleneck for your particular situation.