Use own buttons to navigate tab control pages

[4321z]

Hi,

I want to navigate through tab control pages using buttons that i have placed on the form and not the standard tabs can anyone help.

thanks

 

[4321z]

Sorry tried a few things but didn't consider the setFocus that seems to work fine whoops!!

 

[jimlee]

You can do this two ways:

1) go to the properties of the tab control , find the 'style' property (in the format section) and choose 'none'. This will remove the tabs.

2) reference the pages from your vba module something like this:
Forms![yourForm].Controls("yourTabControlName").Pages("Your Page Name").PageIndex = 0

that will set the desired page to the front of the other pages (so you can see it)

Also, if you go to the properties of the tab control , find the 'style' property (in the format section) and choose 'buttons'. This will give you buttons instead of tabs but will behave in the same way as the tabs did.

jimlad

 

[jimlee]

ah fair enough sound far easier! (by the way, I put my numbers in the wrong place when explaining the 2 ways of doing things ,just incase this confuses anyone!)

jimlad