ms access - display subform only when needed

[bambo]

Hi,

I have a form with a tab control containing in each tab several subforms.

I'd like to improve performance of loading the form by loading the subforms content only when the related tab is clicked (on the first time it happens for main form current record).

any ideas how to best to do this?

Thanks,

[Ecniv]

Hi,

I'm not one for using sub forms, but the only way I can think of is that the sub forms are reset to the data form as you click on the tab. You can capture the tab click/activate so it is only whether you can have blank subforms (blank form) and change them to the forms you want to show - which should also force a refresh as you change them.

post back if you get a solution