dynamically add a subreport to a main report

[Dave D]

Is it possible to have a main report and then, using VBA, dynamically add different sub-reports to the main report based on differing conditions?

If not, is it possible to dynamically move the positions of the sub-reports on the main report (based on which sub-reports don't have data and won't show in Preview mode)? I tried changing the sub-report.Top attribute using VBA but received an error stating the attribute isn't accessible using VBA.

Thanks.

[June7]

None that I know of.

My solution was to have a label display when the subreport has no data

[Dave D]

I have 4 sub-reports on the main report. My boss wants certain spacing on between the sub-reports. I can throw in the label to display if no data is present, but that messes up the spacing.

I'll play around with opening the report up in design mode, moving sub-reports on the form with VBA, and then displaying the form. I'm not sure it will work but it's my last alternative.