Tab Control - Slow opening

[John M]

I have a Tab Control on a form which holds all my main data entry forms. It
has (at the moment) 7 tabs, most of which have a form with a subform (or 2)
on them. Most of the forms involved have some calculations in them,
involving background queries to get the required results.
The upshot is that it takes about 13 - 15 seconds (on 1Ghz machine) to open
this form. Once it has opened it works excellent! but it is so slow opening.
Is there any way this can be speeded up somehow, eg only loading Tab pages
when clicked or something?

[Allen Browne]

Hi John

First thing is to turn off Name AutoCorrect (Tools | Options | General), and
set the SubdatasheetName to [None] in all your tables (Properties box in
table design view). For other ideas, see Tony Toews' Performance FAQ at:
http://www.granite.ab.ca/access/performancefaq.htm

If you have done that and still need to do more, you can delete the
SourceObject property of your subform controls, and then use the Change
event of the Tab control to assign the property.

If it suits, you can even place a single subform directly on the form (below
the tab control, which shrinks vertically to very small). Use the tab's
Click event to load the appropriate subform into the single generic subform.
This approach has the advantage that memory is only ever used by one subform
at any one time.

If you do reassign the SourceObject, be aware that Access will automatically
assign whatever it things is appropriate for the LinkMasterFields and
LinkChildFields properties, so you may need to clear these or reassign the
desired field names after it messes them up.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"John M" <jo*****@bigpond.com> wrote in message
news:V0*******************@news-server.bigpond.net.au...

I have a Tab Control on a form which holds all my main data entry forms. It
has (at the moment) 7 tabs, most of which have a form with a subform (or
2)
on them. Most of the forms involved have some calculations in them,
involving background queries to get the required results.
The upshot is that it takes about 13 - 15 seconds (on 1Ghz machine) to
open
this form. Once it has opened it works excellent! but it is so slow
opening.
Is there any way this can be speeded up somehow, eg only loading Tab pages
when clicked or something?