The first thing to do is stop loading the source objects of the sub forms. Make their sources empty, and then only load them on demand, via the tab control's change event (I am assuming the tab control, and not just 7 sub forms directly on the main form.)
Something like:
Private Sub tabCtl_Change()
Select Case tabCtl.Value
Case 1
Me.objSubform.SourceObject = "sfrmCustomer"
Case 2
Me.objSubform.SourceObject = "sfrmInvoice"
etc ...
HTH
Steve Conklin
PS – don't store the calculations, no matter what.
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Thursday, October 1, 2015 1:31 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Speeding up form with multiple subforms
I have a form with 7 (count 'em) sub forms, that takes a long time to load, ~30 seconds. 3 of the sub forms are based on sum queries. What are some general suggestions for speeding it up?
What do you think of the idea of creating tables for some of all of the sum queries? I know this is not "efficient" database design. However, the underlying data is updated only monthly, and it will (I assume) make the form load quicker.
Adam
Posted by: Stephen Conklin <stephenmconklin@hotmail.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (3) |
Tidak ada komentar:
Posting Komentar