Changing data sources and getting an Error on my report

[perducci]

I recently made a report in Access and then changed the data from an Excel table to a linked .csv table. This removed a column [ID] from the table. Now when I open the report it gives me an error "Enter Parameter Value" and asks me to input the [ID] value.



How do I make it stop?

Thanks

[John_G]

You have to fix the report so that it no longer references the column that is no longer there. That's why it keeps asking you for the "parameter".

[perducci]

I have looked through the report and I can't find any reference to that column. There are only 4 fields on this report, so I don't know why it would still give me an error

[John_G]

Check the record source for the report. If it is a query, try running the query outside of the report. If you get the same error, then the query is referencing the non-existent field. Remove the column from the query and it should be fine.

John