Using Tabbed Dialog Control 6.0

[technoknow]

Hi, I'm using the SStab control and linking to an Access 2000 db using an ADODB.Connection. I have about 100 labels on each tab that are showing info from my database. Is there a way to just connect the labels on the "active tab" instead of all of the labels connecting when the form loads? I have 12 tabs so when the program loads there is a dramatic drop of system recources. I would appreciate any guidance on this.
Also, I have declared my variables in a code module as global variables, does this effect the system resources?
Thanks,
Jim

 

[BobWman]

If you are using a data control, you are probably out of luck. If you are populating the data using ado code, you can use the click event for the SSTab control to populate the tab that is clicked. For example:

Private Sub SSTab1_Click(PreviousTab As Integer)

Select case SSTab1.Tab
Case 0
' Populate tab 0
Case 1
' Populate tab 1

Etc.

Hope this helps.

 

[technoknow]

I'm hard coding my connection so I will give your suggestion a try, thanks for the quick response.
Jim