Access Form takes too long to load
Posted on 2013-11-24
I have an access form with several sub-forms that takes too long to load.
I have used the Page control so that each sub-form is on a separate page because the users don't need to see all the info in one go, but they do need quick access when required.
Something I have tried is to make the sub-form control unbound and then use the Page's on_click event to set the Source Object value. However, clicking the page's tab doesn't seem to trigger the on_click event. The user has to click the middle of the page, which means an extra click is required.
What other techniques can I use to speed-up the load?