Help with tabbing through subforms on tabs

[kvin]

Hello, I've created a database that is based on 10 tables (there were too
many fields to create 1 giant table). I want to enter data through a form, so
I created a form with tabs. The first tab has the fields included in table 1
and is the main form. I have placed 1 subform on each of the remaining tabs
corresponding with the remaining 9 tables. So here is my problem...

When I finish tabbing through Tab1, I can't move on to the next tab/subform.
Instead, the cursor just appears in the first field on the tab I just
finished with. I would like to create an event that would automatically move
the cursor to the first field on the next tab/subform.

Then, at the end of Tab10, I want the cursor to go to the first field on Tab1
in a new record.

Any help would be much appreciated!!

Thanks very much in advance.

 

[DStegon via AccessMonster.com]

Do you have the data entry in text boxes???? If so use the textbox event
"lostFocus"

Private Sub textBoxWhatever_LostFocus()
me.pgeTab2.visible=2
me.pgeTab2.SetFocus
me.pgeTab1.visible=false 'if you want the first Tab page to "go away"

End Sub

the pgeTab above is the name of your tabs on the form.