AdamFeerst
Registered User.
- Local time
- Yesterday, 17:56
- Joined
- Sep 21, 2015
- Messages
- 63
I have an important form that has 7 (count 'em) sub forms. It takes several seconds to load locally, and 15-20 seconds for people at remote locations. I need it to load more quickly.
The data BE is on an SQL server. 6 of the 7 subforms use a parent-child relationship. I use pass-throughs for those forms RecordSources, establishing the source via OnLoad; e.g.,
How can I speed it up? What are best/better practices for working with linked subforms with an SQL BE?
Thanks
The data BE is on an SQL server. 6 of the 7 subforms use a parent-child relationship. I use pass-throughs for those forms RecordSources, establishing the source via OnLoad; e.g.,
Me.frmSub1.Form.RecordSource = "qryPassThrough1"
I use OnCurrent to filter the subforms; e.g.,
stSQL = "SELECT ... WHERE ParentID = " & me.ParentID
CurrentDb.QueryDefs("qryPassThrough1").SQL = stSQL
Why 7 subforms? The each display different information; e.g.,CurrentDb.QueryDefs("qryPassThrough1").SQL = stSQL
- List of individual services, AcctNos, and financial summary for a Parent.
- Financial totals by service type.
- AKA names
- "Child", subsidiary customer companies.
How can I speed it up? What are best/better practices for working with linked subforms with an SQL BE?
Thanks