Seting Default Tab Control

[emprimi]

hello all! I use this site very frequently when I run into issues and I can always find an answer... until today, hehe.

anyway, here is my problem. in my application, on the main form if you will, are 4 tab/page controls. when the user uses the navigation buttons on the bottom (these are access' form navigation buttons), regardless of which tab they were on, i want it to automatticly display the first tab, first. i have figured out that it is on the form_onactivate event that i must do this, however i cannot seem to get that one tab to the be the default. i have tried using the page index, set focus, i have tried calling a control on that tab/page, refreshing the form, simulating a user "click"... needless to say i am fresh out of ideas.

any suggestions would be greatly appreciated. thank you for all the help you have given in the past too

 

[RuralGuy]

Two possible choices:

In the Form_Current event put the following code:
Me.YourTabCtl = 0 ' Move to the 1st TabPage

Or use Stephan Lebans NavButtons where you have all of the control you need: http://www.lebans.com/recnavbuttons.htm

 

[emprimi]

Thank you so much!!!
Putting the me.tabs = 0 in the current event worked! I cannot thank you enough!

(thank you for link as well... i am intrigued to look at it and look around the site...)

 

[RuralGuy]

You're welcome.

 

[GUIDO22]

I cannot seem to get this default tab setting to work :

I have entered the following : Me.tabCtrl = 0

and I get : Error 2448 - You Cant Assign value to an Object

Is this an old version of the Tab control? - I am using Access '97.

Thanks
G

 

[RuralGuy]

I don't have ac97 but maybe you need to specify the .Value property.

 

[GUIDO22]

Well done -sir!
Carlsberg don't do Access programmers - but if they did.....you'd definitely be one of them!

Thanks.

 

[RuralGuy]

Great news. Now both of us know a little more than we did earlier. Thanks for posting back with your success.