Returning to correct Tab

[John Ortt]

Hi everyone,

I have a search box above a tabbed form and when I run the search I refresh
the data on each tab.

This works fine but the problem is that it always defaults back to the first
tab.

Is there a way to find which tab is visible prior to the code running so
that I can return to it at the end?

Thanks in advance,

John

 

[Allen Browne]

Examine the Value of the tab control.

It will match the PageIndex of whichever page was active.

 

[John Ortt]

Thanks for the advice Allen,

One more quick question if you don't mind,

How do I examine the value of the tab control?

Thanks again,

John

 

[Douglas J. Steele]

Me!NameOfTabControl should return the number of the page that's being
displayed (its Page Index value).

 

[John Ortt]

Thanks Doug,

I'll try it now.

Me!NameOfTabControl should return the number of the page that's being
displayed (its Page Index value).

 

[John Ortt]

Worked a treat,

I just used the following code:

Dim CurrentTab As Integer
CurrentTab = Me!TabMenu

'The rest of the code went here

me!TabMenu = CurrentTab

Thanks guys.