Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Display error message on empty report 1

Status
Not open for further replies.

Zuzia

Programmer
Jun 21, 2005
12
US
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
 
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
 
Thanks so much, both of these threads proved excellent, and I have the result that I was looking for.

Zuzia [gorgeous]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top