From: Bob Alston on
I have a multi tabbed form with about 10 tabs, each has a subform with a
different record source. I also use the fsubnavigation tool from
Access 2002 Desktop Developer's Handbook by Litwin, Getz, and Gunderloy.

I would like to switch from static record source to setting the record
source when the sub form has the focus. I think this will make form
load faster.

Unfortunately, the fsubnavigation form uses an on open vba code. I
tried just moving it to on got focus but that didn't work.

Anyone previously encountered this issue and have the solution?

Instead, could I set the subforms as not visible until the tab for the
sub form has the focus? If I do that will it keep the form from
Processing the record source until it becomes visible?