Ok lets hope I can explain this well.
I have a form called frm_MainMenu
On that form there is a Tab Control called tabMainMenu
On the tabs are several sub forms
The Second Tab is called Employers
Onthe second tab there is a sub form called sfrm_Employers
The third tab is called Reporting
When on the Reporting tab I have created a report builder that uses various criteria to open an list of employers in a popup/modal continuous form based on the criteria selected. This works perfect.
On the popup form I now have a list of companies and I want to be able to click a button that will do the following
Close the popup form
That should be as easy as ..
In the underlying frm_mainmenu go to the correct tab in the tabMainMenu tab control
That should look something like this ...
Last, and this is the part I can not figure out i want to go to the record in the sfrm_Employers subfrom that is on the Employers tab that corresponds to the record I was on when I pushed the button on the Pop up form.
I hope this explains what I am doing
Any help would be greatly appreciated.
I have a form called frm_MainMenu
On that form there is a Tab Control called tabMainMenu
On the tabs are several sub forms
The Second Tab is called Employers
Onthe second tab there is a sub form called sfrm_Employers
The third tab is called Reporting
When on the Reporting tab I have created a report builder that uses various criteria to open an list of employers in a popup/modal continuous form based on the criteria selected. This works perfect.
On the popup form I now have a list of companies and I want to be able to click a button that will do the following
Close the popup form
That should be as easy as ..
Code:
docmd.closeIn the underlying frm_mainmenu go to the correct tab in the tabMainMenu tab control
That should look something like this ...
Code:
tabMainMenu.Value = 1Last, and this is the part I can not figure out i want to go to the record in the sfrm_Employers subfrom that is on the Employers tab that corresponds to the record I was on when I pushed the button on the Pop up form.
I hope this explains what I am doing
Any help would be greatly appreciated.
