DON'T print report if no records?

B

_Bigred

I have a Canteen Card report with a source qryCanteenCardNeeded.

When I set a person to "Yes" for needing a canteen card then open this
report it will show a card for each person that I designated.

However I have all my reports set to print from 1 macro. When I print even
if there are no people needing canteen cards it will still print the report
with no table data.

How do I set it so if there are no people needing a canteen card, it doesn't
print out?

TIA,
_Bigred
 
A

Allen Browne

Cancel the No Data event of the report.

You will want to open the report from code (not a macro), so you can handle
and ignore error 2501.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Printing report in booklet format 9
Report Print Anomaly 2
creating report to print 4-up index cards on Avery 3381 3
Grouping problem with labels report form 6
Report printing multiple pages based on query 2
Form, instead of Report, Prints ??? 0
Printing on a preprinted form from multiple printers 4
Box does not grow with txt fields 2

Top