capturing and setting the page of a control tab

[Paul Ponzelli]

What VBA expression can I use to get (and also set) the page of a tab
control?

When I open a form that has a tab control, I would like the tab control to
display the last page that was displayed before the form was last closed. I
know how to store a value in a configuration or system table, but what I
can't figure out is how to obtain that value from the form. I've tried
various combinations of the Page, Pages and PageIndex properties, but I
can't get it to work.

If the form is named myForm and the tab control is named ctlMyTabControl,
how can I write an expression that will return the current page displayed in
the form's tab control?

Thanks in advance,

Paul

 

[Rob Parker]

Hi Paul,

The tab control's value property contains the currently displayed page of
the control. So, to save it, simply save:
Me.ctlMyTabControl.Value

To change the page via code, use a statement such as:
Me.ctlMyTabControl.Value = 2
This example would cause the third page of the tab control to gain focus,
since the Value is a zero-based index.

HTH,

Rob

 

[shanesullaway via AccessMonster.com]

Hey Paul,

I found this link and was going to paste for you to follow but when I came
back I noticed you had already been helped. Decided to go ahead and paste
the link any way just incase you decide you would like to use it.

HTH,
Shane

http://www.accessmonster.com/Uwe/Fo...reference-the-name-of-a-page-in-a-tab-control

 

[Paul Ponzelli]

That's exactly what I was looking for.

Thanks, Rob.

 

[Paul Ponzelli]

Thanks for the info, Shane.

 

[shanesullaway via AccessMonster.com]

Your welcome. Maybe it will come in handy somewhere along the way.

Shane