Using Command Button to Open Page Index

[Mrkeith]

Forum,
I'm having a problem trying to open an page index on my form page. Can anyone help with this problem? I would like to have the command button open the (SWD) tab on the same form. How can I do this? This (SWD) tab has a chart that i would like for the command button to open in print preview so i can print the chart out. Can this be done?

Thanks for your help in Advance.

 

[boblarson]

Is this a regular tab control or the new navigation form in Access 2010?

 

[Mrkeith]

Bob, I believe this is a regular tab in Access 2007. I guess I should be more clear. This is a form that has page tabs across the top. When you clilck insert page button, you create a new tab. I hope this is helpful.

Thanks Bob.

 

[boblarson]

If you know the index of the page you can just set your main tab control to it in the click event of the button.

Me.MainTabControlNameHere = x

where x is the index number of the page. Or, if you may have those move around because of adding pages and such, you can use the page name

Me.MainTabControlNameHere.Pages("PageNameHere").SetFocus

And most of the time you can also use

Me.PageNameHere.SetFocus

 

[Mrkeith]

bob,

I'm sorry but where is the main tab control located? How do you get to it?