Cannot view report - error 2501 (1 Viewer)

[JohnPapa]

I am running A365 as a frontend to SQL Server
I have a form called "frm3" which is made up of 6 subforms

I have created a report "rpt3" which shows the same data and is made up of 6 subreports

The 6 subreports use the same queries as the 6 subforms

When I try to call rpt3 from frm3 I get error 2501

I call rpt3 using
DoCmd.OpenReport "rpt3", acViewPreview

 

[JohnPapa]

If it helps the report appears if I use

DoCmd.OpenReport "rpt3", acViewReport

But this does not show the report buttons such as Print, Export to PDF etc.

Also, I get error 2501, if I call

DoCmd.OpenReport "rpt3", acViewPreview

from other forms, not just form "frm3"

 

[bob fitz]

can you open other reports in Preview

 

[JohnPapa]

can you open other reports in Preview

Yes, no problem.

 

[bob fitz]

Does the report open ok if you use:
DoCmd.OpenReport "rpt3", acViewPreview
in the Immediate Window

 

[JohnPapa]

I moved the subReports from the Report Header to the Detail section and it works.

I vaguely remember having a similar problem which was solved after the subreports were moved to the Detail section

 

[JohnPapa]

Perhaps someone can provide a technical explanation. Is it a bug?

 

[LarryE]

Subreports usually have Master/Child links established, but I don't think they work properly if the subreport is in the header or footer.

 

[JohnPapa]

So most probably it is a bug, one that may take a lot of time to find a solution!!!

 

[The_Doc_Man]

I'm going to post a link that gives detailed issues that could lead to this error. The link involves a product that I do not know and there neither recommend in favor or warn against, but there are some nuggets of wisdom in the article independent of the product.

How to Fix Runtime Error 2501 in MS Access? | Stellar

Encountering runtime error 2501 in MS Access? Follow our step-by-step guide to resolve the issue and optimize your database performance.

www.stellarinfo.com

This should NOT be construed as recommending any product.

 

[Pat Hartman]

Perhaps someone can provide a technical explanation. Is it a bug?

it likely has to do with the order in which events run. At the time the report header is being formatted, something required does not yet exist. Since subforms/subreports open before the main form/report, the underlying code might only open subforms/subreports that are in the main object's detail section. Therefore when the header is formatted, any subreports have not been opened and so don't exist.

I have only seen the 2501 error when an event runs the OpenReport method and the report has no data and so closes. This isn't mentioned in the list. But all my code that opens reports traps for this error.

 

[LarryE]

So most probably it is a bug, one that may take a lot of time to find a solution!!!

No I dodn't think its a bug. Subreports need the Master/Child links to work properly and only the Detail section or Groups have them. And as Pat said, the subreport opens first so it needs those records in the Detail section or a Group section.

 

[JohnPapa]

I'm going to post a link that gives detailed issues that could lead to this error. The link involves a product that I do not know and there neither recommend in favor or warn against, but there are some nuggets of wisdom in the article independent of the product.

How to Fix Runtime Error 2501 in MS Access? | Stellar

Encountering runtime error 2501 in MS Access? Follow our step-by-step guide to resolve the issue and optimize your database performance.

www.stellarinfo.com

This should NOT be construed as recommending any product.

I came across this article in my quest for a solution and did try a few of the suggestions.

 

[JohnPapa]

No I dodn't think its a bug. Subreports need the Master/Child links to work properly and only the Detail section or Groups have them. And as Pat said, the subreport opens first so it needs those records in the Detail section or a Group section.

Thanks for your input. Why do you say that subreports need the Master/Child link to work? I did not find anything in the documentation regarding this and as you can see, in practice, there is no need for the link.

 

[Minty]

I think the issues is that without any data in the detail section the report won't attempt to load any subforms.
I suspect you can put sub reports in the header as long as you have some data in the detail section.