Create Subform with VBA or Macro

[incipientclarity]

Hi everyone,



I've designed a form that contains a subform. The subform displays a report that is generated based on some inputs from the original form. My issue now is that when I load the original form, the subform causes lag. I've tried using the Visible property, but since the subform still sits on the original form, even when it is not displayed, it is still executed.


Is there any way to write a code such that either the subform is "inactive" on loading the original form or the subform is created only after user clicks on a button?

Thank you!

[June7]

A subform/subreport is created by establishing a subform container control on main form. The SourceObject of the container control can be a table, query, form, report. Don't set the SourceObject property in design view. Use code to set the property.

You are showing a report on form?

[incipientclarity]

Actually I got it to work. Turns out my code was wrong.

Thanks for your suggestions! Inspired me to look at the SourceObject property.