Is there a way to view a report inside a control? I want to have a form
with a list of reports and view the report in another control on the same
form in Access 2007.

Is this possible?

Thanks.

Matthew Wells
matthew.wells (AT) firstbyte (DOT) net

On Aug 25, 8:54*pm, "Matthew Wells" <matthew.we... (AT) firstbyte (DOT) net>
wrote:
It is possible in Access 2010.

Search for NavigateTo.

P.S. Reports can only be seen in report view.

Forms or Reports can be viewed via a Subreport Control in a Report. At
least through Access 2003, however, a Subreport Control cannot be placed on
a Form, nor can a Report be viewed in a Subform Control on a Form.

--
Larry Linson, Microsoft Office Access MVP
Co-author: "Microsoft Access Small Business Solutions", published by Wiley
Access newsgroup support is alive and well in USENET
comp.databases.ms-access


"Matthew Wells" <matthew.wells (AT) firstbyte (DOT) net> wrote

"exebat" <srdjan.vasiljevic (AT) gmail (DOT) com> wrote

You don't even have to use navigate to. Sub-form controls in access 2010
supports both forms and reports.

It likely this was changed for the new navigation control (which is really
just sub-forms anyway). So, prior to 2010, no, but for access 2010, you can
simply drop a sub-form control into a form, and the source object drop down
combo shows and allows the selection of a reports in addition to forms as we
always could.


--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
Pleasenospam_kallal (AT) msn (DOT) com

On Aug 26, 3:26*am, "Albert D. Kallal" <PleaseNOOOsPAMmkal... (AT) msn (DOT) com>
wrote:
Yes, but using NavigateTo he can also give the WHERE clausal to the
report the easiest way possible.

"exebat" <srdjan.vasiljevic (AT) gmail (DOT) com> wrote


Ah, ok. Very good point - one I had not thought of.

I suppose one could just stuff/change the sql into the form/reports record
source, but I not tested doing this.


--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
Pleasenospam_kallal (AT) msn (DOT) com

On Aug 26, 9:37*am, "Albert D. Kallal" <PleaseNOOOsPAMmkal... (AT) msn (DOT) com>
wrote:
It is BrowseTo.

Here is the code I use


DoCmd.BrowseTo acBrowseToReport, ReportName,
"MainForm.Navigationsubform", ReportWhereClausal, , acFormReadOnly