A report doesn't throw out a message, it makes a report.
So what you should do is to check the number of records in the query for the report BEFORE calling the report. If it's > 0, go ahead. If it's 0: show the message box instead. That's a few lines in a macro and/or in VBA.
Kees
Hello all,
I'm building a database to send out work orders to my coworkers. I currently have the report based off of a query that I have called "action item by name." The report runs correctly except for cases in which there are no applicable records. What it does in this case is it kicks out a blank report. What I would like for it to do is display a message box stating something to the effect of "you don't have any action itmes" or something along those lines. I also have a macro set up based on this same query that emails the report to the individuals involved. I would like it to behave in the same way when that macro is run. Thanks! Jeremy

Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic