run-time error 2130

[uoghk]

I created several reports and ran well without error before, & I have not change them.
But today, I run them again, it shows run-time error 2130 with message:
The report name 'SaleReport' you entered in either the property sheet or macro is misspelled or refers to a report that doesn't exist.

I can open the SalesReport and other reports in design view.
It look OK.

What can I do to fix?
Thanks.

[CJ_London]

from your post

The report name 'SaleReport'
I can open the SalesReport

[uoghk]

I typed my report correctly, it is "SaleReport".
The run-time error 2103 comes when running "OpenReport" command as below:
DoCmd.OpenReport "SaleReport", acViewPreview

When I edit the report in design mode, it shows properly.
And it also correct in Print Preview mode.

[Welshgasman]

Access does not lie, if it cannot find it, it is generally due to a typo.

[CJ_London]

For the avoidance doubt suggest provide a screenshot of the navigation window showing the report

[June7]

Does every report have this issue?

Could provide db for analysis.

Sometimes weirdness is corruption that cannot be explained. Things to try:

1. Compact & Repair

2. Decompile then recompile

3. import everything to a new db file

4. reinstall Access

5. rebuild reports

[moke123]

You can see what's in the reports collection

Sub ListReports()
    Dim rpt
    For Each rpt In CurrentProject.AllReports
        Debug.Print rpt.Name
    Next
End Sub

[uoghk]

Thank moke123.
using your code, i find that some of the report names are wrong, so Access cannot display the report in run-time.
Because these report names are getting from a database table & someone changes these report names that i don't know.
Thanks help for all of you.