Display Report with form also displayed

[tony9bb]

I'm a newbie with Access 97. This forum has helped me tremendously, just by reading previous posts, but now I'm stuck.

I have two questions/problems:

1.)I have a report that has five subreports created by a form for date range input. The report data is fine. But when it displays in Print Preview, it's in the background and the only way to view it is to close my form. I need the form to remain displayed, since I'm getting the dates entered for my page header. What am I missing??

2.) I want to retreive a sum total from subreport1 footer and a sum total from subreport 2 footer and calculate a percentage. I tried putting this--Reports!x001Charges!Total Of Payment_Amt--- in the control source of the main report, but it errs with not recognized as a field or expression. Can I do this?

Thanks in advance for your help.

tony9bb

 

[nickjar2]

tony9bb,

I will answer Q1 first. Is your form a pop up form? If it is (and u want it to remain a pop up form) you could always make it invisible on previewing the report. ie

me.visible = false
docmd.openreport "report",acpreview

and on the close event of the report u would have something like:

forms![name of form].visible = true

I will look at part 2 more closely and hopefully get back 2 u.

Nick

 

[tony9bb]

Thanks Nickjar2. It is a popup form and your solution works.
It looked too easy once you know what you're doing.

I've tried numerous Control Source options to get the calculation on my main report, but have not found the right solution. Your help is greatly appreciated.

tony9bb