Tabbing through tab control pages

[khaymon]

How do I set the tab order so that it moves to the next page (tab control)?
My form has 7 tab controls, but the tab seems to move only in circles on my
first tab control page. Thanks.

 

[ruralguy via AccessMonster.com]

I usually put a 1x1 pixel transparent TextBox (almost invisible) as the last
control in the Tab order on each tab page and set the OnEnter event to
SetFocus to the 1st control on the next tab.

 

[khaymon]

Can you tell me how to "set the OnEnter event to SetFocus to the 1st control

 

[Linq Adams via AccessMonster.com]

Private Sub HiddenTextBox_Enter()
FirstTextBoxNextPage.SetFocus
End Sub

 

[khaymon]

Thanks, that worked. How do I get the last field to go to the next record?

 

[khaymon]

Can you tell me the code needed to get the last field on the form to go to a
new record?
Thanks.

 

[ruralguy via AccessMonster.com]

To what do you have the Cycle property of the form set?

 

[khaymon]

It's set to "All Records" currently.

To what do you have the Cycle property of the form set?

 

[ruralguy via AccessMonster.com]

I would think hitting <enter> in that last control on the last tab would move
you to the next record. Do not put the trick textbox on that form or set it
invisible so it can not get the focus.

It's set to "All Records" currently.

To what do you have the Cycle property of the form set?

[quoted text clipped - 7 lines]

 

[khaymon]

It's "circling" through the last page of the form when I hit enter.

I would think hitting <enter> in that last control on the last tab would move
you to the next record. Do not put the trick textbox on that form or set it
invisible so it can not get the focus.

It's set to "All Records" currently.

To what do you have the Cycle property of the form set?

[quoted text clipped - 7 lines]

FirstTextBoxNextPage.SetFocus
End Sub

 

[ruralguy via AccessMonster.com]

Then make the trick TextBox visible and in the OnEnter event of it add Me.
Recordset.MoveNext.

It's "circling" through the last page of the form when I hit enter.

I would think hitting <enter> in that last control on the last tab would move
you to the next record. Do not put the trick textbox on that form or set it

[quoted text clipped - 7 lines]