How to load a subform in a navigation form

[mixtr]

In my old database (v1) I have a function that when you double click on an employee's name on a report, the employee form opens (if not already open) and the record is set to that employee.



I have revamped the database (v2) and I'm using a Navigation Form. One subform for employee profile and one subform to open the reports under a different navigation button (just buttons and labels with OpenReport macro). The reports open in a separate window.

frmmain (navigation form)
frmemployee (under navigation button 1)
frmreport (under navigation button 2)

I understand that when frmreport is loaded, frmemployee is unloaded.

When I double click on an employee's name on a report, I would like frmemployee to load under frmmain but I don't know how to load the form. BrowseTo opens frmemployee under frmmain but closes the report, which is not a desirable effect. Any ideas?

I'm hoping this is something simple but so far even page 10 of Google couldn't give me the answer.

[June7]

Don't like and never use navigation form/control. Why did you decide to? Why are you selecting employee from a report object and not a form?

[mixtr]

The Navigation Form is a nice way to clean up the whole application. It allows to regroup the forms under a nice interface and get rid of the ribbon and sidebar to open/navigate forms and reports. This database is primarily used by computer illiterate people and I want to remove as much "Access" as possible. It also allows for a quick and easy navigation between forms.

Selecting employees from reports (and other forms) is a really nice way to quickly access the employee's form without having the user opening the correct form and searching for the employee to make correction.

[June7]

I use db option settings and code to customize the user interface. I hide navigation pane and ribbon, disable shortcut keys and menus, and disable X close and File Exit.

I have never built interactive reports.

[mixtr]

I was finally able to find the solution:
Forms![frmmain].NavigationSubform.SourceObject = "frmemployee"
then you can set focus to frmmain
The only minor issue is that the Navigation Button does not change to reflect the subform currently active.