Thanks Bruno but I cant see how that will work,
I have a number of reports which theoretically I can output as word
documents. I have a form with a list box that shows the reports. On pressing
the print button on the form, it adds code to the OnPrint sections of the
selectede report to initiate the output to Word routines. In order to output
the whole report to Word, the user has to go to the next page until they
reach the end. At that point I want to close the report. All the running
code is initiated by the printing process of the report. How can I detect
the end of the report and pass back control to the form that initiated the
proccess to do the The "DoCmd.Close acReport, me.Name, acSaveNo" on the
close event bit
Thanks
Phil
"Bruno Campanini" <br****************@tin.it> wrote in message
news:G6**********************@news4.tin.it...
"Phil Stanton" <di********@stantonfamily.co.uk> wrote in message
news:41*********************@mercury.nildram.net.. . In code I am opening a report in deign view, adding code to the report to
output it to Word in an editable form. I then want t close the report but
not save the changes.
Is there any way or preventing the option to save changes from being
displayed (the answer is always no)
The "DoCmd.Close acReport, me.Name, acSaveNo" on the close event does
not work
TIA
Phil
Put
DoCmd.Close acReport, ReportName, acSaveNo
in your code, not in On Close of the report.
Bruno