Tabbing between tabs on a form

[mikem]

I have a form that contains 2 tabs.
After I get to the last field on the first tab, I want to tab to the first field on the 2nd tab.
is there a way to do this?

[isladogs]

I expect there are several ways of doing this. For example, in the after update event of the final control of the first tab, add code similar to this:

Private Sub Tab1LastControlName_AfterUpdate()
  Me.Tab2FirstControlName.SetFocus
End Sub

Modify control names as appropriate
Doing that will only work if you change the contents of the last control on tab1. If that's not guaranteed, use a different event but similar code.

[mikem]

worked perfectly
thanks

[isladogs]

Excellent. Glad I could help