Do access subforms that are not visible still update/requery? If not, can this be behavior be configured?

I have an old Access database that is being upgraded to work with Access 2007. The client is complaining that it is slow now.开发者_StackOverflow社区 I am looking for ways to optimize it.

There is one subform that is in a particular tab on the form. I have been wondering -- does the subform still update/query even when it is not visible?

If this is configurable --- how?

All controls refresh/update whether visible or not.

It's generally considered good practice to not load recordsets until they are needed. If you have many subforms in a tab control, you can use the tab control's OnChange event to load/unload your subforms, or, alternatively, to set the recordsources.

However, with only a couple of subforms, this is not likely to be a big help. But with a half dozen or so, it's a different issue.

You can remove the recordsource from the subform and add it back when the form is made visible, or simply remove the whole subform and add that back.