Thread: On No data (2003)
2008-05-20, 19:31 #1
- Join Date
- Jan 2001
- Thanked 0 Times in 0 Posts
On No data (2003)
I have some code that runs when a report has no data:
Private Sub Report_NoData(Cancel As Integer)
MsgBox "There is no information for that selection", vbInformation
Cancel = True
When the message comes up that there is no information for that selection, I get another message box after that that says "The OpenReport action was cancelled". Is there a way to suppress that second message?
Subscribe to our Windows Secrets Newsletter - It's Free!
Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!
+ Get this BONUS — free!
Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!
2008-05-20, 20:46 #2
- Join Date
- Mar 2002
- Thanked 16 Times in 16 Posts
Re: On No data (2003)
You asked the same question in <post:=688,978>post 688,978</post:> - see my reply there. <img src=/S/smile.gif border=0 alt=smile width=15 height=15>