Select second tab

[lloydmav]

I need to select the second tab(Page) on a form when I navigate to it from a specific button.

Could someone tell me how to go to a specific tab?

I can't make the it the default because normally I would like the first tab(Page) to be displayed first.

Thanks in advance

 

[Mile-O]

IF you are on Page1 and you want to go to Page2 then it is simply a case of:


Page2.SetFocus

 

[lloydmav]

Thanks

Thought it was something simple

 

[lloydmav]

Oops didn't work

It didn't seem to work!

I've called the pages "In Progress" and "Rejected"

I wanted the page to be selected from a button on a different form so I have;

Private Sub Command57_Click()
On Error GoTo Err_Command57_Click

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "StatusPage"
DoCmd.OpenForm stDocName, , , stLinkCriteria
Rejected.SetFocus
Exit_Command57_Click:
Exit Sub

Err_Command57_Click:
MsgBox Err.Description
Resume Exit_Command57_Click

End Sub


It comes up with the error "Object Required"

So why won't it recognise the tab (object)?

Thanks for the help!