Does loading additional forms drain resources?

I have two complex forms with multiple tabs and subforms that take from 6 to
10 seconds to load. This is after I've done everything I can think of to
improve performance - indexing query criteria fields, only putting fields I
actually use in the queries, turning off Name Autocorrect, etc.

I'm now thinking that in order to reduce the users' wait time to open these
forms, I could open them when the application first opens, but make them
invisible until the user clicks a button to "open" one of the forms, at
which time I would simply make it visible. When they click a command to
close one of the forms, VBA would hide the form again in case they wanted to
open it again later.

Does such an approach have a downside? That is, does keeping complex forms
open but invisible while users are performing other operations in the
application - does this create a drain on system resources, or can Access
easily handle a couple of open forms without any loss in performance for
other operations?

Thanks in advance,

Paul


.

Loading