Search results for query: *

Thanks dhookom. I took your concept and did it a little different. I created two queries; one for the main report and another for the sub report. I changed the report to use those two queries so that they wouldn't change. When I process the report, I update those two queries and then output the...

That sounds like a good idea! I will try it and let you know how it works!!

I am using code. In fact, I changed my process, but I am still getting the save to pop up. Here is my new code. ' OPEN REPORT DoCmd.OpenReport "rptPrtArticleInspectionSheets", acViewDesign ' ADJUST SOURCE Reports!.Report.RecordSource = strSQL...

I create a report where I change the report source every time the report is created. I open the report in the Print Preview mode. When I go to close the report, it asks me to save the report objects. I don't want to save them, I just want to close the report. I am not seeing how to do this...

That works perfectly!!! Thank you so much!

No. How would I get the total records and the running sum to place into the text fields?

I have it almost working. Here is what I did: I create two different labels and placed them on the Page Header. When formatting the ReportHeader, I hide the alternate label and show the original label. When formatting the ReportFooter, I hide the original label and show the alternate label...

Sorry for my confusion. It's not the Report Footer that needs to change. It is the Page Header. When I start printing the Report Footer; which is where my SubReport is located, I need the Page Header to change a field that will show that it is now printing the SubReport The main report is a...

Correct. How would you go about changing the header when the Report footer is printing? That is what I am not sure about.

Hello, I have a report that is using 3 columns. Once the report is completed, I want the subreport; which is a normal full page report to print. This is working correctly, but I want the page header to change when it gets into the subreport. Is this possible? Thanks for your help in...