Access multitab with sunforms loading speed

[Philip Leduc]

I build an (split) application including a form with multiple tabs and most
of them include a subform with data from related tables.
The application lives in a multiuser environment and needs speeding up.
Not every user however needs to view the same tabs but then again,
ocassionaly they might.
In stead of building multiple forms, I was wondering if there is a way to
load the info on a subtab only when you click on the tab.
1) keeping the tab invisible does not seem to do the trick
2) loading an empty container (subform query with recordsource where xxid
=0) could work? but I am not sure there is no better solution.
I am sure on the longer term, we should probably upgrade to SQL but a
relatively quick fix would be useful

thanks,

Philip

 

[Jeff Boyce]

Philip

Upgrading to SQL would not necessarily speed up your form.

I've (successfully) use the approach you propose, setting the subform's
control source to either "" or to a query with WHERE xx=0, then changing the
source when the subform's "tab" is selected.

To do that, I used the tab control's OnChange event, and evaluated which
tab/page was selected (the .Value of the tab control).

Regards

Jeff Boyce
Microsoft Office/Access MVP