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

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