Subreport on a Form?

[TJEngel via AccessMonster.com]

Hello Access Monsters,

Can you display a Subreport on a form?

I am using Listboxes so that users can pick options in order to display facts
on topics. Currently, I am just enabling the visibility of command buttons
that open the reports containing the facts on whichever topic the user has
selected.

BUT it would be great if I could just house the report as a subreport on the
form, and just enable its visibility whenever the user selects the
corresponding topic from the Listboxes.

I've used a locked subform, but I was thinking that a subreport would look
nicer/more professional.

Thanks for any help!

TJ

 

[Jeff Boyce]

I'm confused ...

Reports are reports, forms are forms. Why would you want to put a subreport
on a form? (I don't know if Access knows how to properly handle something
like that.)

Why not create a form that looks more like your report, if you want a
subform that displays output more like your report?

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

 

[TJEngel via AccessMonster.com]

Right-o. I got a bit confused. Too...much...Access! Must rest!

Cheers,
TJ

I'm confused ...

Reports are reports, forms are forms. Why would you want to put a subreport
on a form? (I don't know if Access knows how to properly handle something
like that.)

Why not create a form that looks more like your report, if you want a
subform that displays output more like your report?

Regards

Jeff Boyce
Microsoft Access MVP

Hello Access Monsters,

[quoted text clipped - 18 lines]

TJ

 

[VWP1]

Changing the appearance of textboxes to have invisibility can remove the
"data entry" feel and look. USing design view, change the background of the
textboxes storing the info on the subform, from normal to transparent, and
make th border transparent also.

Right-o. I got a bit confused. Too...much...Access! Must rest!

Cheers,
TJ

I'm confused ...

Reports are reports, forms are forms. Why would you want to put a subreport
on a form? (I don't know if Access knows how to properly handle something
like that.)

Why not create a form that looks more like your report, if you want a
subform that displays output more like your report?

Regards

Jeff Boyce
Microsoft Access MVP

Hello Access Monsters,

[quoted text clipped - 18 lines]

TJ