Display error message on empty report 1

[Zuzia]

Hi,

I have 4 combo boxes bound to individual queries. From these combo boxes I generate a report of matched records. I need help in generating an error message if the resulting report is blank i.e. the combo box selections have no record matching. Any suggestions on doing that will be appreciated.

Thanks,
Z

 

[RoyVidar]

The report has a On No Data Event, of which there are numerous posts here. I suggest try to search for it in this forum.

Here is one thread703-903180, you'd probably also need to trap the 2501, see for instance thread703-842035

Roy-Vidar

 

[Zuzia]

Thanks so much, both of these threads proved excellent, and I have the result that I was looking for.

Zuzia