Can an Access 2007 report be displayed within a form?

I need to display an Access 2007 report within a form. The users enter information in the upper portion of the form and they need to see a report on the bottom half of the screen. Is it possible to have a report displayed within a form?

Thanks.
newbie46Asked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Jeffrey CoachmanConnect With a Mentor MIS LiasonCommented:
You can also place the Form and the Report in a certain area of the screen, then set the Moveable property of both to: NO

Then you can use the form to (dynamical) filter the report (if that is what you are after).

Here is a very basic sample.

JeffCoachman
Access-EEQ26618060FormFilterRepo.accdb
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Not in 2007, but you can in 2010 (new feature).

You could build a UI where the Form and Report were side-by-side (and moved with each other as needed) but it could be quite time consuming.
0
 
newbie46Author Commented:
Please explain further as to how to set up the form and report side by side.

thanks.
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
Jeffrey CoachmanMIS LiasonCommented:
How good are you with VBA coding?
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Connect With a Mentor Infotrakker SoftwareCommented:
Open a Form, and then Open the Report.

In the Report's Open event, include code that will move that report to show side-by-side with the Form.

Me.Top = Me.YourForm.Top
Me.Left = Me.YourForm.Left + Me.YourForm.ActiveWindowWidth

etc etc

Of course, if you open these forms Maximized, then you'll have some unwanted effects.
0
 
newbie46Author Commented:
thanks.
0
All Courses

From novice to tech pro — start learning today.