Tab Control

[crwc]

I want to be able to tab to a new record when I have tabbed through the last tab control.

I have a from with six tabs. What I would like to do is when I've tabbed my sixth tab I want to get a new record so I can input new info.

The code below is what I have used so I can tab my pages.

Private Sub route_KeyPress(KeyAscii As Integer)

End Sub

Private Sub route_KeyDown(KeyCode As Integer, Shift As Integer)
If KeyCode = 9 Then
Me.ptofinterestTab.SetFocus
End If
End Sub

Now when I've hit my last tab, (ptofinterestTab), on the page, I want to go to a new record. How do I do this? Or...what code do I need to make this happen?

TIA
C

 

[crwc]

I figured it out! If anyone is interested in knowing what I did it's the following:

I used the

DoCmd.GoToRecord......acNextRecord

instead of SetFocus for my last tab.

Can't say if this is the best way to make it happen, but at least it works!

Thanks again to all who comtemplated my question!

 

[stormin_norm]

Perfect for me! My users were just asking for this yesterday!! You must be psychic!