What do you mean tab page? Using Microsoft tab control or the entity subforms like Rick does in the ABCD?

I absolutely abhor the tab control. HOWEVER, if you insist on using them, then you can use code like this to open a form and go to a specific tab (which Access calls a "Page")...

    DoCmd.OpenForm "CustomerF"
    Forms!CustomerF!TabControl = 1

The TabControl object itself has a value. Set the value to whatever page you want to have focus. The page number is the "Page Index" property of that page.

I've never covered this in any of my videos because I HATE, HATE, HATE the tab control... but this would actually make a quick fast tips video. Might help someone else too.

Ok Rick in Access 2019 I tried

DoCmd.OpenForm "MainMenuF"
    Forms!MainMenuF!TabControl = 7

and received an error that Microsoft Access could not find the field "TabControl" referred to in your expression.

So then I tried

DoCmd.OpenForm "MainMenuF"
    Forms!MainMenuF.TabControl = 7

thinking that changing to a period wouldn't make Access think it was a field, then got an error Application-defined or Object-defined error.

It's a work around but I could also just re-arrange the pages so the one I want to open to is the first page.

TabControl is just a word there as a placeholder, you need to replace TabControl with the ACTUAL name of your tabcontrol. If you click on the tab control properties and go to name, that's what you need to put there.

Thanks Adam, I went "Duh" as soon as you said that lol.

Adam or Rick, Happy Xmas Eve to all, I was rereading these helpful tips and was wondering if there is a Tech Help video on the Entity subforms that Rick does in the ABCD database?

Have a very blessed Christmas everyone!

Sorry to keep posting but I figured it out.  You just overlay the subforms and make them invisible and then add buttons as tabs to make the one visible you want to see.  That is truly easier than the tabbed pages, whatever they are called :)

Jerry,

A better way is to change the SourceObject.

The extended cut of the Vehicle Maintenance Tech Help video shows you how to do this.