Dick Abo
orthorabod at yahoo.com
Mon Mar 15 12:38:51 CST 2004
I have a form from which the user views a report in Print Preview mode by clicking the ‘View Report’ button. I would like user to respond to the question to ‘Publish’, or ‘Not Publish’ the report after the report is viewed. If the user decides to Publish the report, I export the report to Word and then save it in Ascii format (MS-DOS text w/layout). I could incorporate a separate button on the form that just generates the Access 2000 report in acPreview mode. I would prefer to detect when the report has been closed by the user so that I can then ask the question, “Publish or Not Publish” the report and to execute the remaining code that is behind the existing ‘View Report’ button? Can you kindly give me some advice on how to do this! TIA, Rick Do you Yahoo!? Yahoo! Mail - More reliable, more storage, less spam