Opening a report results in error

[bayman]

I'm attempting to open a report with a simple command:

DoCmd.OpenReport "rptName", acViewPreview

Executing the command results in a 2501 error. If I open the report from the Navigation Pane, it opens as expected. I'm using Access 2010. I've added code to ignore the 2501 error, which results in nothing happening. Anyone have an idea as to why this might be happening?

Thanks in advance.

 

[spikepl]

what is 2501 error

 

[Cronk]

"Anyone have an idea as to why this might be happening?"

No, not with the negligible amount of information provided.

Did you try opening the report without the preview? Does the report contain any code? What is the recordsource for the report?

 

[bayman]

what is 2501 error

Generic run-time error. The accompanying message is "The OpenReport action was canceled."

 

[bayman]

"Anyone have an idea as to why this might be happening?"

No, not with the negligible amount of information provided.

Did you try opening the report without the preview? Does the report contain any code? What is the recordsource for the report?

Tried opening without preview. Same error.

Report contains no code.

Recordsource is a linked SQL table.

 

[sneuberg]

Probably won't help but try a compact and repair.

 

[AccessBlaster]

I'm attempting to open a report with a simple command:

DoCmd.OpenReport "rptName", acViewPreview

Thanks in advance.

Do you really have a report named rptName?

 

[bayman]

Probably won't help but try a compact and repair.

Just closing and re-opening the database solved the problem. Amazing.