A family of Microsoft relational database management systems designed for ease of use.
No. What you're seeing is the way the Nav form works, it only has one subform control. Switching tabs just resets the subform control's SoureObject property and that "opens" the form, query, etc. got the selected tab.
To get what you want, use the Tab control so you can have separate subform controls on each tab page.