Michael, There was no response on either email. Jim Wagner ________________________________
________________________________ From: Michael Van Der Stad <[email protected]> To: [email protected] Sent: Monday, May 18, 2009 4:02:28 PM Subject: Re: [ms_access] On no data event question --- On Mon, 5/18/09, luvmymelody <luvmymelody@ yahoo.com> wrote: From: luvmymelody <luvmymelody@ yahoo.com> Subject: [ms_access] On no data event question To: ms_acc...@yahoogrou ps.com Date: Monday, May 18, 2009, 10:22 PM Hello All, I have a macro that opens a report then filters the report by department codes and then outputs the reports to a folder as a snapshot viewer file. So I have 25 departments and the reports output to the folder with the filter for each report. I have Cancel = true in the on NoData event if the department has no data. My problem is that the departments that have no data output the first departments data to the report. Is there a way of truly canceling the report output and not create the report at all? Jim Wagner [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
