Open a form on a specific page tab 1

[Hfnet]

I have a form (Use) with a two tab control subform. I have two command buttons on a main form (main), and I want one button to open the new form with Tab Page 0 in the front, and the other button to open the same form but with Tab Page 1 in focus.

Can anyone help?

Thanks

 

[Softop]

There may be another way to do this but this is how I would tackle it...

With each button set up a OpenArgs value to pass through to the subform.

Private Sub Command1_Click()
Dim stOpenArgs as String
Dim stDocName as String
Dim stLinkCriteria as String

     stOpenArgs = "0" [COLOR=green] 'for Tab1 [/color]
     stDocName = "subFormName" [COLOR=green] 'name of subform [/color]
     DoCmd.OpenForm stDocName, , , stLinkCriteria, , , stOpenArgs

End Sub

Private Sub Command2_Click()
Dim stOpenArgs as String
Dim stDocName as String
Dim stLinkCriteria as String

     stOpenArgs = "1" [COLOR=green] 'for Tab2 [/color]
     stDocName = "subFormName"  [COLOR=green]'name of subform[/color]
     DoCmd.OpenForm stDocName, , , stLinkCriteria, , , stOpenArgs

End Sub

Then in the subform "On Load" event include the code...

Private Sub Form_Load()

    Me.TabCtl = Me.Form.OpenArgs [COLOR=green]'where TabCtl is the name of your Tab Control[/color]

End Sub

Hope this helps. Good Luck!

 

[Hfnet]

Thanks, worked a treat