Changing a subreport with VBA

[DoniFromMars]

I have a report 'Report A' which contains a subreport,
'subreport A'. I would like to use vba to alter Report A to use Subreport B instead of Subreport A.
I'm getting all kinds of errors.
Is it possible to do this?
If so, what is the syntax?
Thanks!

 

[lewds]

Hi.....

Most things are possible, depending on effort.

Least effort...

Duplicate reports, one with subreportA and one with subreportB

Command buttons on your form to choose the report.

More effort.....

A conditional statement in the event procedure of a command button to run the proper report based on other criteria.

More effort.....

Composite report containing both subreports (not visble)
On open event of the report, make visible the proper subreport based on other criteria.