OpenForm to specific tab

[rivereridanus]

Hi everyone,

I have an input form that opens another second input form. The code below opens the form to the correct record.
However, the form that I open has a bunch of tabs on it, and I want to open the specific record right to the tab "Technology_Page". Does anyone know a way that I might be able to do that right from this statement?

 DoCmd.OpenForm "ProjectDetailsActive", acNormal, , "PPID = " & Me!PPID

[June7]

Can't. Not directly. Use the OpenArgs argument of that line to send value to the form. Then in the Open event of form set the active tab page. Example:

DoCmd.OpenForm "ProjectDetailsActive", acNormal, , "PPID = " & Me!PPID, , , "TP"

Then in Open event:

If Me.OpenArgs = "TP"
Me.tabcontrolname.pagename.SetFocus
End If

If Technology_Page is the name (not the caption) of the tab page then use it in place of 'pagename'.