How to open report 'elegantly' if nothing to show.

T

ThomasAJ

DoCmd.OpenReport "ABC"

When query behind it has nothing in it the report just flashes (or at least
its window does).

Can something be put in the OPEN/LOAD event that can cause an elegant
OpenReport.
 
D

David W. Fenton

Cancel the NoData event of the report.
Click to expand...

....and add an error handler to the bit of code where
DoCmd.OpenReport was called (you'll want to ignore error 2051).
 
Top