#Error

[teiben]

I have a calendar control in which the user selects a starting & ending date, which runs a query and outputs to a report. It works great, except if there are no records between the dates, then the report fields and calcualted controls show #Error; Is there a way to eliminate it?

 

[Elana]

Put some code on the "on no data" event of the report to deal with this.

Use a msgbox indicating there are no records, or have a text box that prints "no records" when there is no data.