Change active tab in a tab control using VBcode.

[CrArC]

Hello there... AGAIN.
I want to change the active tab in a tab control in a form using VB. I've tried:

form_formname.tabcontrol.pages(2).setfocus
in this example I was trying to select the second tab of the two in the control.

I decided that I need tab controls to cut down on the number of forms I will need to accomodate all the mess I'm making!
Basically though, I need to be able to change the current tab by means of a command button, and ideally, the tabs themselves will be hidden (just revealing the contents of each tab) so the buttons must be used to navigate.

Any help appreciated! Thanks.

 

[Bat17]

collections in Access are Zero based
form_formname.tabcontrol.pages(1).setfocus for second tab

 

[CrArC]

Haha, that works a treat! Ok thanks