Hello to everyone out there on this rainy day in Detroit,

I need help in suppressing a report from printing or previewing in print preview mode if there are zero records in the query that the report is bound to. Right now, the report prints with #Error all over.

Does someone know how I can do that? What event I should act on or disable?

I was thinking on the report open event, check if the query's recordset is null then msgbox the user, then stop the report from going to print preview. But it's not working, well it's displaying the msgbox but I don't know how to disable the report from going to the report preview state.

Thanks for any help.

FJA

Please do not reply to this topic. I posted it in the wrong place, I meant to post it in the MS Access area. Pardon me.

FJA.