Report record count

[peterbowles]

Hi,

Is there a simple command like the one below you can use for reports if there are no records found

if me.recordsetclone.recordcount = 0 then
msgbox "no records Found

 

[pbaldy]

What I do in this situation is use the "On No Data" event of the report to cancel its opening (you could just put up your message box if you want). You also have to trap for error 2501 in the procedure that opened the report.

 

[peterbowles]

ho do you do that?

 

[Rich]

If you use the search function here I'm sure you can find some code for the NoData event