Embed a report in a form?

[Guest]

Hi,

Please can you advise if it is possible to embedd a print preview of a
report into a form using an active x control? If so how?

Many thanks in anticipation

Rgds

Colin

 

[Larry Linson]

Please can you advise if it is possible
to embedd a print preview of a
report into a form using an active x
control? If so how?

You can embed a Form in a Subform Control on a Report.

You can NOT embed a Report in a Subreport Control on a Form.

Subform and Subreport Controls are "native" Access Controls; I am not aware
of any ActiveX controls for viewing Access Reports.

It has been announced that the next version of Access (and Office) will
support native generation of .PDF files. Check to see if Adobe has a Control
for viewing PDF?

On the other hand, it is trivially simple to run an Access report from a
Form, using the DoCmd.OpenReport command in the code behind a Command
Button's click event. I've had this reuirement many times, but never had a
requirement to embed a Report.

Larry Linson
Microsoft Access MVP