Subform Loading (Access 2K)

Topic

New Reply

I’m trying to prevent a subform from loading on a multitab form, except when the tab is chosen for view. Any suggestions. Thanks

Reply | Quote

Replies

Don’t populate the default sourceobject of the subform control. Instead, use the change event of the tab control to test which page is being selected and then if it is the page in question, check to see if the sourceobject of the control is an empty string. If it is, set it to the name of the subform being used to populate the control. Once the subform control is populated, you can leave it alone. Be sure you leave the master and child link fields set by default. They are ignored anyhow if there is no sourceobject set.

Reply | Quote

Don’t populate the default sourceobject of the subform control. Instead, use the change event of the tab control to test which page is being selected and then if it is the page in question, check to see if the sourceobject of the control is an empty string. If it is, set it to the name of the subform being used to populate the control. Once the subform control is populated, you can leave it alone. Be sure you leave the master and child link fields set by default. They are ignored anyhow if there is no sourceobject set.

Reply | Quote