From: Lee on
I have a Master report that contains the header, footer, and group
information. A sub report for products is used as the detail. I would like to
programatically change which subreport is used based on the product. Are
there events etc. within the report to allow me to do this?
From: Marshall Barton on
Lee wrote:

>I have a Master report that contains the header, footer, and group
>information. A sub report for products is used as the detail. I would like to
>programatically change which subreport is used based on the product. Are
>there events etc. within the report to allow me to do this?


Put both subreport in the detail section, one on top of the
other. Then use code in the details section's Format event
to make one visible and the other invisible.

--
Marsh
MVP [MS Access]