Help Needed with Tab “Next Page” and “New Record” Buttons

[skyrise]

My database is divided out over 3 tab pages based on one Main Table and related subforms.

I’m trying to come up with a “Next Page” command button script to move between tabbed pages so that the user doesn’t have to scroll all the way back to the top of the page to select the next tab.



I’m also trying to get the New Record button to go to a new record on Tab1 and place the cursor on Field2. Currently, the New Record button is located on Tab3 and open a new record on Tab3.

[skyrise]

Looks like I got a couple of pieces of code to work for well for me on all Tab pages.


For moving from tab to tab using command buttons (TY:don94403):

Private Sub btnGoToTab3_Click ()
Me!Field2.SetFocus
End Sub


For going to a new record using a command button (TY:Allen Browne):

Private Sub btnNewRecord_Click ()
If Me.Dirty Then Me.Dirty = False
If Not Me.NewRecord Then RunCommand acCmdRecordsGotoNew
End Sub