go to page?

[redblaze]

hi iv built my form with a tab on it. it has several pages. but i dont know the code to go to a certain page once a button has been clicked. anyone have any ideas? thanks!

 

[Rich]

MyPageNumb.SetFocus

 

[redblaze]

new problem

hey thanks for the help it worked...but theres 1 more thing...

how can i got to a new record in a subform? the subfrm is located in a page, this is what i have right now but it doesnt work.

Private Sub cmdAddCustomer_Click()
Customer.SetFocus
DoCmd.GoToRecord acDataForm, "sfCustomer", acNewRec
End Sub

the subform is called sfcustomer, and the form which it is based is called fcustomer. i have tried both but neither seem to work

 

[Rich]

Set focus to the page, then the subform, then DoCmd. etc