Charlotte Foust
cfoust at infostatsystems.com
Mon Mar 15 12:48:37 CST 2004
You can sink the Close event of the report on your form using the WithEvents keyword. Check out WithEvents in on-line help (and in the archives for extensive discussion). If you need additional help, post back. Charlotte Foust -----Original Message----- From: Dick Abo [mailto:orthorabod at yahoo.com] Sent: Monday, March 15, 2004 10:39 AM To: accessd at databaseadvisors.com Cc: orthorabod at yahoo.com Subject: [AccessD] Detecting when an Access Report has been closed! 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 -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com