How to move from one tabbed page to another with a command button 1

[rew2009]

I have form with ten tabbed pages. I want to move from the first page to the 10th page using a command button rather than the tab control at the top of the form. How can I do it? Below is the code from the command button created by the wizard. Thanks Russ

Private Sub cmdGoToPage10_Click()
On Error GoTo Err_cmdGoToPage10_Click


Screen.PreviousControl.SetFocus
' DoCmd.FindNext

Exit_cmdGoToPage10_Click:
Exit Sub

Err_cmdGoToPage10_Click:
MsgBox Err.Description
Resume Exit_cmdGoToPage10_Click

End Sub

 

[ZmrAbdulla]

You want the 10th page of the Tabcontrol to be on focus right?

Private Sub Command6_Click()
    Me.TabCtl0.Pages(9).SetFocus
End Sub

or

Private Sub Command6_Click()
    Me.TabCtl0.Pages("PageName").SetFocus
End Sub

Zameer Abdulla

 

[rew2009]

Thank you, That worked fine Russ