--- On Mon, 5/18/09, luvmymelody <[email protected]> wrote:
From: luvmymelody <[email protected]> Subject: [ms_access] On no data event question To: [email protected] 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]
