Ignoring no-data reports

From: howard (anonymous_at_discussions.microsoft.com)
Date: 08/11/04 

Date: Wed, 11 Aug 2004 04:09:34 -0700

just set the cancel propert of the NoData event to 1
i.e. in the property pages, events tab, choose the 'On No
Data' event, click the '...' button, select the code (not
macro). The VBA code window opens up, and within the
subroutine add the Cancel=1 code :

Private Sub Report_NoData(Cancel As Integer)
cancel=1
End Sub

you might put a message box in (MsgBox "no
data",vbexclamation + vbokonly, "Nothing To Do") to tell you