Record source updated (1 Viewer)

[MarioM]

Hi,

I tried to update the query in my record source of the report. There are two tables in query joined as they should be. I literally added just one column (with its alias) from one of the tables, something like: "Table1.Column As Alias" in the Query Bilder, and the report now won't open. I did debug, it crashes on DoCmd.OpenReport command in code.

Did I forget to change it somewhere else? Or something else?

 

[Uncle Gizmo]

If you put the query in the query builder grid and run it, does it work ok?

 

[MarioM]

Yes, it works when I run it. I get a table made by that query.

So the query is ok. But still, report won't open. Don't understand why, changing that query is the only update I've made.

 

[jdraw]

Suggest you post a copy of the database (zip format) for readers to study the issue.
Remove anything confidential and only a few records are necessary for review.

 

[gemma-the-husky]

Maybe the report doesn't like the query
Maybe changing the report has caused a corruption

I hope you have done this, but keep regular unused backups of your database, so you can easily recover to a safe earlier version.
If not you may have to delete the report, and make a new one.