Subreport no data question??

[paulmcdonnell]

Hi Guys and Galls,

A QUICKIE!!

I have a report with several sub reports...If the subraport has no data access doesn't display it at all.


This is ok but I want the Mesage "No report data" displayed in its place...How do i test whether the particular report has data or not so that I can display my message.


CHeers

PAUL!

 

[Sohaila Taravati]

Put this code in the On No Date behinde the reports design:

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

 

[Rich]

You have to use the HasData method to display a textbox in it's place, examples have been posted here