embedded teports in Access

[Anja]

Hi everyone,

I have a question about forms and reports in Access and whether they
could be made to share the same window.

So what I am trying to do is the following:

I have a report that is fed by a query and the user can set the filters
for the query through a form window. What I wanted to do was display
the report in the same window. So, the user sets the filter criteria
and it updates the report. It all works if I launch the report in
another window but it would be nicer to just have one window for this
and have the record get embedded in the window.

Is there an easy way to achieve this?

Thanks,

Anja

 

[Alex Dybenko]

Hi,
not sure I understand you, but perhaps you can just print preview the form?
form can also act as a report

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

 

[Marshall Barton]

Hi everyone,

I have a question about forms and reports in Access and whether they
could be made to share the same window.

So what I am trying to do is the following:

I have a report that is fed by a query and the user can set the filters
for the query through a form window. What I wanted to do was display
the report in the same window. So, the user sets the filter criteria
and it updates the report. It all works if I launch the report in
another window but it would be nicer to just have one window for this
and have the record get embedded in the window.

Is there an easy way to achieve this?

Not that I ever heard about. You might be able to achieve
an near equivalent effect by positioninig the form and
report windows appropriately within the Access window. See
the MoveSize method in VBA Help.

 

[mcescher]

I had to do something like this.

I had several different selections (Months, weekdays, locations) that
the user could select and change the output. I had user make
selections and then click an Update button. This would create the SQL
statement on the fly from the users selections. Fed the SQL statement
to a Subform so the user could see what information would be returned.
Then When the user was ready he/she pushed the report button, and this
pushed the SQL statement into the report as the record source.

In Access 2002, you cannot drag a report onto a form as a sub form (I
just tried)

HTH,
Chris M.