Reputation: 265
in my MS Access 2013 application, I am using a Navigation Form as a top layer to connect all my subforms.
How do I stop Access from requerying the subforms whenever I change tabs (forms) ?! (Basically I just want to use the navigation tabs as a way switch the other forms that remain open but hidden)
This seems like a basic feature that i cant't seem to figure out.
Thank you in advance!
Upvotes: 1
Views: 1037
Reputation: 5917
Unlike Tabs, NavigationForms has a menu and a subform control where your "target forms" will be "loaded". So every time when you click a navigation button, your target form will be "loaded/opened" into the subform control.
It means you are not re-querying your forms but unloading and loading.
for your purpose you might well use the normal Tabs.
Upvotes: 1