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).
 

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

Trying to create a report that will list unmatched records by Ticket Primary Key 0
long-time report fails intermittently under Access 2007 SP2 6
A couple questions BEFORE using Office 365 0
OpenReport/OutputTo 0
Getting Radio Buttons to work, that are inserted via AutoText 0
Text in note pane of "normal" display suddenly much larger 1
Macro works, but only if you 'step' through it - Word 2000 2
Outlook Loses Login/Password on Exchange After CCleaner Runs 0

Top