report filter that has no records 1

[Lhuffst]

If the report filter returns 0 records, how do I modify the filter to show a message with no data?
If I use the nodata event, I end up with a openreport error 2501. To trap this error, I need the onclick event of the report form which I don't have access to.
I would like to have either a message box pop up saying there aren't any matches for the given criteria OR the report caption (or a text box) to say...No data found
Any ideas anyone? Thanks lhuffst

current filter example

 [t_Events].[EventCatCode] IN ('INSPECTION','SAMPLE') AND [EventTypeAbbrv] <> 'SELF' AND [COMPLETEDATE] <> NULL

 

[dhookom]

If you cancel the printing/displaying of the report, this will cause the 2501 error. If you can't trap for it, then you will probably need to display the report. You can try add a text box to the Page Header section with a control source of:

=IIf([HasData]=0,"There is no data to display",Null)

Duane
Hook'D on Access
MS Access MVP

 

[Lhuffst]

Great. Thanks I'm leaving for the day but will definitely try it tomorrow. Thanks for the quick response.

 

[Lhuffst]

That worked beautifully. Thanks