Hosting reports on forms

[Arthur Dent]

Hi all,

Quick question ( i hope ) ....

Is there any kind of control or method in Access, which would allow me to
take a report in the db, and "host" is on a form in the db?
So in essence, the form would have some sort of "viewer" frame or something,
which i could point at different reports, based on user button-clicks (or
some other method).

Thanks in advance,
Arthur Dent.

 

[Larry Linson]

Is there any kind of control or method in Access, which would allow me to
take a report in the db, and "host" is on a form in the db?
So in essence, the form would have some sort of "viewer" frame or
something, which i could point at different reports, based on user
button-clicks (or some other method).

No, you can embed a Form in a Subreport Control, but you can't successfully
embed a Report in a Subform Control. You can have a Form with Command
Buttons, or a Combo Box, or other Control that will allow you to choose a
Report and then use the DoCmd.OpenReport in VBA code to open the Report you
want to view.

Larry Linson
Microsoft Access MVP