Runtime error 2059

[School Boy Error]

Hi, I have a report based on a query that appears on screen exaclty as expected. It has a button with one line of VBA to export the report to a pdf and I am getting the error:Run time error '2059'Cause for Concern Log cannot find the object '/1'The vba code is simply:

DoCmd.OutputTo acOutputReport, "Green Form Summary", acFormatPDF, "", False

Which works fine on the other report I have so I don't know what the difference is....

[CJ_London]

almost certainly it will be something in your Green Form Summary report. Possibly some code trying to update a control called /1

[School Boy Error]

I've looked through the property sheet but can't seem to find anything. The labels etc that refer to elements in the report all refer properly (as far as I can see). Any ideas of where I might look further?

[pbaldy]

Shot in the dark, but does the report refer to a form that gets closed after the report is opened?

[School Boy Error]

No, the form stays open and needs to be manually closed behind it...

[aytee111]

The same error https://access-programmers.co.uk/for...d.php?t=263516

"That particular error almost always means that some error has occurred in the form or report you were trying to output based on having named something in the form's RECORDSOURCE query or on a control's ROWSOURCE query, when you spelled the object wrong or named an object that didn't appear in the referenced query's underlying recordset.

I.e. the query processor failed to find an element in something that implies use of a query. "

[School Boy Error]

I saw that thread but there was no solution. I can't find the ROWSOURCE query but found the RECORDSOURCE and that refers to the correct query...

[aytee111]

Stop the code on that line and before it executes, export the query manually from the nav pane to a pdf.

[School Boy Error]

I've attached a copy of the database. It's the mainSummary report that is causing me the issue. The other one works

[pbaldy]

It doesn't error for me, but with no data it also doesn't export anything.

[aytee111]

If you do post #8 you will get an error.

[aytee111]

Paul, he has On Error Resume Next. Same happened to me!

[pbaldy]

Ah. Perhaps using the correct report name in the code would help...

[School Boy Error]

Ah. Perhaps using the correct report name in the code would help...

Arggghhhh really? I'll check as soon as I get to work!! I do have an on error resume next but commented that out while testing - it's there in case people click cancel on print out export...

[pbaldy]

Sorry, yes. You have a non-existent report in the output code.