Display a report on a form

[Guest]

Hi

Wondering if someone can answer a question. Can you display a report on a form.

I have a simple report that includes a few groups each with a few items, some numbers and group totals. I would like to display this report on a form so the user can scroll up and down the report within the form

Is this possible

il

 

[Larry Linson]

It does not appear to be possible with Access 2003. I tried to embed a
report in the subform/subreport control on a form, and could not find a way
to make it work... it would not accept the report in design view, nor would
it allow me to set the SourceObject of the control from code. However, you
can certainly open a report in preview mode from a form, and have both the
report and the form open.

Interestingly, however, you can embed a form in a subreport control on a
report.

I don't know why there is a difference.

Larry Linson
Microsoft Access MVP

Hi

Wondering if someone can answer a question. Can you display a report on a form.

I have a simple report that includes a few groups each with a few items,

some numbers and group totals. I would like to display this report on a
form so the user can scroll up and down the report within the form.

 

[MGFoster]

Larry Linson wrote:

Interestingly, however, you can embed a form in a subreport control on a
report.

I don't know why there is a difference.

Larry Linson
Microsoft Access MVP

A form can be changed into a report, but a report cannot be changed into
a form.

Rgds,

MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

 

[Larry Linson]

If you were not just drawing a parallel, in the case where you embed a Form
in a Subreport Control, the same Form still works nicely as a Form in a
Subform Control in a Form, too. If it is changed, that must be automatic and
temporary/hidden/???

Larry Linson
Microsoft Access MVP

 

[Guest]

thanks

I'll rethink my requirements

il