"Arno R" <ar***********@tiscali.nl> wrote in message
news:42********************@dreader2.news.tiscali. nl...
<pi********@hotmail.com> schreef in bericht
news:11**********************@g43g2000cwa.googlegr oups.com...
Sounds like dodgy database design, but that's your choice. Having two
tables with identical structures is a bit odd...
Simple, though. Make a copy of the report. Then open it in design
view, and change the recordsource to the new table. (view the
properties tab).
Hmmm ...
Maybe also having two identical reports with only another recordsource is a
bit odd ... ?
DoCmd.OpenReport "YourReportName", acViewNormal, "qryOtherRecordsource"
won't do what you need?
Arno R
"DoCmd.OpenReport" will not work because it will only filter the report
source.
If you are NOT using runtime, you can open the report in design mode, change
the source, save then print.
DoCmd.Echo False
DoCmd.OpenReport Reportn, acDesign
Reports("rptMyReport").RecordSource = "qryMyReportSource"
DoCmd.RunCommand acCmdSave
DoCmd.Close acReport, "rptMyReport"
DoCmd.Echo True
Otherwise change the source query before opening the report.