Reports with 'No Data' 1

[rgbanse]

I'm using DoCmd.OpenReport... with the necessary criteria and conditions - opens fine. At this point, is there a way to test the report for a 'No Data' state using VBA. I've tried creating a constant and usnig the 'On No Data' function within the report to pass a value to the variable with out any success.
Help always appreciated.
thx
RGB

 

[PHV]

There is a NoData event procedure with a Cancel argument.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[DomFino]

RGG,
Just to add to the previous post. Type this code on the No Data Event.

Private Sub Report_NoData(Cancel As Integer)
    MsgBox "There is no data for this report. Canceling report..."
    Cancel = -1
End Sub