Tab Control - Tab between pages

[manakar]

How do I use the TAB key to move from the last field on one page to the first field in the next page? When I hit TAB it opens a new record. From what I've read, you have to use code builder but I haven't had any success yet (I have little to no experience with code building). Right now I have the "Cycle" property under the "Other" section set to "Current Record" to prevent a new record from being opened.



The last field is called POSTAL CODE on the PERSONAL DATA page and the first field is called RACE on the PHYSICAL DESCRIPTION page.

[burrina]

Me.TabCtl27.Pages(2).SetFocus

is an example, of course change names to that of your own.

HTH

[manakar]

Thanks so much for the code. Which event should I put on? Also, just to make sure, "TabCtl27" is replaced with the name of the "Tab Control" and "Pages(#)" stays the same? Or do I have to put the name of the page?

Me.[Personal Data Form].Pages(1).SetFocus
or
Me.[Personal Data Form].[Physical Description].SetFocus

[June7]

That's always the hard part, figuring out what event(s) to trigger code.

Pages(#) is referencing the page by index. Index begins with 0. Use your actual tab control name.

Try the OnExit event of the last control on the page.

Do you have subforms on the tab pages? If so,

Parent.TabCtl0.Pages(1).SetFocus

If not a subform, use Me instead of Parent.