Try This.

J

JB1

I recieved the same error after altering column names, then trying to run the report again. I sucessfully renamed the control sources on the report, but couldn't find the source of the error, even after searching through all the related code and form properties.

I finally determined the cause was I had set up a sort using the old column name.

To fix this, I rclick on the form, chose "Sorting and Grouping", then using the down arrow changed the name of the colum to the updated column.

EggHeadCafe - .NET Developer Portal of Choice
http://www.eggheadcafe.com/default.aspx?ref=ng
 
A

Allen Browne

Thanks for posting the solution.

There are indeed lots of places to look:
- Sorting'n'Grouping box of report (as you say)
- report's Filter and OrderBy properties
- control source of controls on report.
- report's Record source query/table, including its Filter and OrderBy
properties
- code, macros (particularly Filter or WhereCondition of OpenReport.)

Then there's the problems where Access gets confused over the Name
AutoCorrect values, so that disused Captions and Alises and previous names
of fields come into the mess as well.
 
Top