Hey everyone,



Interesting problem:



I've created a generic subform which can be view through one of two main 

forms. These main forms are wrapped inside of another form which acts only 

as a place holder for a TabControl.



Problem:



In my subform, I detect the parent of the subform, and then load a 

recordset based on this. However, it seems that the TabControl is loading 

all forms and subforms upon opening, and not as the tabs are clicked. How 

can I modify the tab control so that it only loads subforms upon a user 

moving to that page?



Thanks In Advance,

Jack Shedd

I believe you can do this in the OnChange event of your tab control.

Programatically determine the currently displayed page by looking at the tab

control's .Value property, and set the .SourceObject property of the

appropriate subform control.



HTH,



-Roy



Roy Pardee

Programmer/Analyst

SWFPAC Lockheed Martin IT

Extension 8487



-----Original Message-----

From: Jack Shedd [mailto:jshedd@r...]

Sent: Sunday, November 11, 2001 3:52 PM

To: Access

Subject: [access] Subforms and TabControl





Hey everyone,



Interesting problem:



I've created a generic subform which can be view through one of two main 

forms. These main forms are wrapped inside of another form which acts only 

as a place holder for a TabControl.



Problem:



In my subform, I detect the parent of the subform, and then load a 

recordset based on this. However, it seems that the TabControl is loading 

all forms and subforms upon opening, and not as the tabs are clicked. How 

can I modify the tab control so that it only loads subforms upon a user 

moving to that page?



Thanks In Advance,

Jack Shedd