When no records are returned, #Error 1

[KaayJaay]

I want to know if there is a way that i can prompt the user with a message stating that "The criteria you input returns no records." as opposed to getting #Error on my report, or a blank report.

KaayJaay

 

[RoyVidar]

One of the ways, is using the on no data event of the report.

[tt]msgbox "The criteria you input returns no records."
cancel = true[/tt]

Then in the calling form, include some handling to trap the 2501 error:

[tt]on error goto myerr
docmd.openreport "myrpt"...
myexit:
exit sub
myerr:
if (err.number<>2501) then
msgbox err.description
end if
resume myexit
end sub[/tt]

Roy-Vidar