Open a form with a tab control to a specific page in access 2007

[Guest]

Is there a way to have a command button that when selected opens a form to a
specific tab control page. The form that is opened contains multiple tabs
with with corresponding pages. Unfortunately, I cannot use the OpenArgs of
the docmd to set focus because this form is the main application form and the
tab that I am trying to open is not the main one.

I was wondering if there is a way to specifically reference it like:
"Forms!frmMain!tabReport!Report_Page"

Also, would the fact that I keep these control properties set to hidden make
a difference when I reference it?

 

[Allen Browne]

To open frmMain and set tabReport to the page named Report_Page:

DoCmd.OpenForm "frmMain"
With Forms("frmMain")
!tabReport.Value = !Report_Page.PageIndex
End With