Open a specific sub-Form from a different Form

[jpg250]

The Main Form in my database (the one that starts when opened) needs to call a tabbed Maintenance Form, which has several Pages with sub-Forms. How can I open a specific Page in the Maintenance Form from the Main Form. Please note that it is not always the same Page that needs to be opened.

[RuralGuy]

How about using the OpenArgs argument to pass the tab number or name to the Maint Form and then use the OnLoad event of the Maint Form to select the tab you want?
http://www.baldyweb.com/OpenArgs.htm

[jpg250]

Thanks RG. I'll try that.

[RuralGuy]

You're welcome. Let us know how you make out.

[jpg250]

Hi RG. I've got the OpenArgs working to pass in the name of the page I want to set focus to, which is of course a String. I'm stumped now in how to convert that string into an object to which I can set focus. Tried this, but it didn't work: (I'm new to VBA, as you can probably tell)

Dim strOpenArgs() As String
Dim pageToOpen As String
Dim tabpage() As Page
Dim i As Integer

If Not IsNull(Me.OpenArgs) Then
strOpenArgs = Split(Me.OpenArgs, ";")
pageToOpen = strOpenArgs(0)
i = 0
For Each tabpage In Me.TabCtl0

If tabpage(i).Name = pageToOpen Then
tabpage(i).SetFocus
End If
i = i + 1

End
End If

[RuralGuy]

Are you passing a "Name" or a Number?
The code would be: Me.YourTabControlName.Pages(pageToOpen).SetFocus

[jpg250]

Good news.
Yes, I was passing a Name. Changed it to a number and using your code it now works.
Thank you very much.

[RuralGuy]

Excellent! Glad we could help.