Slow opening

  • Thread starter Thread starter Steve
  • Start date Start date
S

Steve

I have a form of Patients, based on a query. Within that form, there
are 2 subforms, based on different queries (Transactions and Visit
Balances). It takes about 7-10 seconds for the form to load and
populate the data, which seems much too slow, as there are only 900
patients and 70000 transactions. What can I do to speed things up?

Thanks

Steve
 
Steve

Is your form based on a query that returns ALL records, including all the
records in all the subforms? If this is true, one approach would be to base
the main form on a query that finds a single record. The single record you
have it find is the single patient you select in a combo box in the header
(said combo box based on a simple query that lists ID and patientname). In
that combo box's AfterUpdate event, requery the main form, and requery the
subforms.

This way, the form loads "empty", and should be quite fast.

Good luck

Jeff Boyce
<Access MVP>
 
Back
Top