No_Data event

[benniesanders]

Hi there,

If I have something like this in the No Data event of a report, how can I keep it from giving an error? If I remove the cancen=true statement, it opens a blank report. If I leave it in, I get an error. Or are there any other ways to let the user know there is no data in a report?
Thanks.

Private Sub Report_NoData(Cancel As Integer)
MsgBox "The report has no data.", vbOKOnly + vbInformation
Cancel = True
End Sub

 

[Garridon]

This FAQ will help:

http://www.tek-tips.com/faqs.cfm?spid=703&sfid=1594&CFID=67185927&CFTOKEN=50458804

Linda Adams
Visit my web site for writing and Microsoft Word tips:

http://www.hackman-adams.com

Official web site for actor David Hedison:

http://www.david-hedison.com

 

[benniesanders]

Thanks, Linda! I'll give it a go.

 

[benniesanders]

It's perfect, Linda. Thanks again!