Hi all,

Whenever I click on the VBA-generated message for my Artists With Multiple Downloads report, I get a nasty run-time error.

This is the error message that comes up whenever I click on OK

Run-time error '2501':
The OpenReport action was cancelled

This is the VBA code I have for the NoData event of the report


Private Sub PreviewReport_Click()
'Open the selected report in Print Preview mode
DoCmd.OpenReport [ReportList Control], acViewPreview
End Sub


I should mention that I am opening that report as well as other reports from the Reports Dialog Box that I designed.

Any ideas?

Thanks in advance,



Ben Horne
Madison Area Technical College student

-------------------------
http://community.webshots.com/user/valerian114

"There are two kinds of people in the world: Those who claim to be Flash junkies and those who actually are Flash junkies"

__________________
Ben Horne
-------------------------
I don\'t want to sound like I haven\'t made any mistakes. I\'m confident I have.

Most likely using FireFox and concocting my next Macromedia Flash project
Snibworks Forums Moderator

Welcome to the New Age

The syntax is

   DoCmd.OpenReport "ReportList Control", acViewPreview

You have brackets [], not quotes "".

Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

Greg,

Thanks for pointing this out. I should mention that I was going by my Access textbook when I was coding the Reports Dialog Box. I guess it's kinda hard to break old habits, right?:D

Thanks again,