Load forms dynamically

Question

I want to restrict the amount of data drawn down to my system. It has multi tabbed forms and i just want to load the form when the tab is selected. Will turning on and off the visibility do the same thing or do i need to load and unload the form?

Thanks

Answer 1

thanks, that makes sense. i have quite a few tab and tabs within tabs. Will it improve efficiency even though it will constantly be loading and unloading the forms or is there a better technique. Should i leave the forms there as unbound and then just bind them when required. At present i leave selections of the data open in a number of different views across the tabs  and the user can either search on a tab or use buttons to hop around the tabs to selected records.

thanks

Answer 2

What you need to do is set the Source Object of the subform when the tab activates. From what you said, "It has multi tabbed forms and i just want to load the form when the tab is selected." it sounds like you have a single form with a tab control. On some of the tabs you have embedded subforms. A subform is a special control that displays a form within the control. A subform control has a SourceObject property. If that property is blank, the subform control will be blank. So what you do is when you activate the tab, set the SourceObject property to the name of the subform and it will load only when the tab is activated. When the tab loses focus, you reset the property to blank.