L
L.A. Lawyer
Question 1 of 2:
I want to change the recordsource for a report. When I try to change the
recordsource before DoCmd.OpenReport (in PrintPreview mode), Access 2000
reports that there is no such report; when I switch the order, Access
displays an error that I can't change the recordsource after the "printing
has started". Error 2191.
Here are my instructions:
DoCmd.OpenReport "MajorEvents", acViewPreview, , "CaseName ='" &
StrCaseName & "'"
Reports!MajorEvents.RecordSource = "SELECT . . . " (The SQL query
is fine.)
What is the proper approach?
Question No. 2:
Although I am experienced Access user, I have never tried to nest a Report
within another (i.e., a subreport). I want to do this and the subreport
will have a different recordsource. I also want the subreport to follow the
main report, starting on a new page. How do I do this?
I want to change the recordsource for a report. When I try to change the
recordsource before DoCmd.OpenReport (in PrintPreview mode), Access 2000
reports that there is no such report; when I switch the order, Access
displays an error that I can't change the recordsource after the "printing
has started". Error 2191.
Here are my instructions:
DoCmd.OpenReport "MajorEvents", acViewPreview, , "CaseName ='" &
StrCaseName & "'"
Reports!MajorEvents.RecordSource = "SELECT . . . " (The SQL query
is fine.)
What is the proper approach?
Question No. 2:
Although I am experienced Access user, I have never tried to nest a Report
within another (i.e., a subreport). I want to do this and the subreport
will have a different recordsource. I also want the subreport to follow the
main report, starting on a new page. How do I do this?