Dcount on filtered records

[DubboPete]

Hi all,

I am trying to stop a report opening if there are no records to print.

My filter is as follows:

SELECT TblDisposals.*, TblDisposals.PrintFlag FROM TblDisposals WHERE
(((TblDisposals.PrintFlag)=0));

It comes up with a blank report. So far so good. What I want to do
is stop the report opening in the first place if there are no records
to print, and replace that action with a message box.

Any clues as to what to put in the report Event On Open?

cheers
DubboPete
17th Century Goat-Herder

 

[John Vinson]

Any clues as to what to put in the report Event On Open?

Use the Report's NoData event instead; and just set Cancel to True.

John W. Vinson[MVP]

 

[DubboPete]

Thanks John, it works very well - not surprising I didn't spot that "On
No Data" event eh?

cheers mate

Pete

 

[John Vinson]

Thanks John, it works very well - not surprising I didn't spot that "On
No Data" event eh?

I didn't either, until someone here pointed it out... DUH!! <g>

John W. Vinson[MVP]