DON'T print report if no records?

  • Thread starter Thread starter _Bigred
  • Start date Start date
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
 
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.
 
Back
Top