OpenReport action canceled

[WineSnob]

I get the OpenReport action canceled when trying to open a report using

Private Sub Command21_Click()
DoCmd.OpenReport "rptNet Worth", acViewPreview
End Sub

The report opens fine directly from the database.:banghead:

 

[rzw0wr]

DoCmd.OpenReport "ReportName", acViewPreview, , , acWindowNormal

You may need the last parts. I have opened reports without the acWindowNormal with no problem.
Are you sure the name is correct.

 

[WineSnob]

I tried that and yes the report name is correct. Still have the issue.

 

[rzw0wr]

What error do you get?

Dale

 

[WineSnob]

Error 2501 OpenReport action canceled.
Also I do not have any error handling code that is trapping it.

 

[rzw0wr]

Rick,
There are some hits on error 2501in Google.

Try looking at some of them.

Most are getting this error from trying to make a PDF file.

Appears 2501is an error when Access has a problem with the query for the report.

Dale