When No Records are returned, #Error

[KaayJaay]

Is there a way that i can send the user a message stating that "there are no records returned for the criteria you input" when a query doesnt return anything, as opposed to my report being filled with #Error signs, or a blank page?

KaayJaay

 

[PHV]

You may consider using the NoData event procedure of the report.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[dhookom]

In addtion to PH's comments, if you want the report to open but show zeros, you can change your calculated text boxes to something like:
=IIf([HasData],Sum(Qty),0)

Duane
MS Access MVP
Find out how to get great answers faq219-2884.