Column was used in a CALC expression but is not defined in the row

  • Thread starter Thread starter af10ry84
  • Start date Start date
A

af10ry84

I tried to sort entries in a form, and then the database froze up. When I
reopened it, I got this message "Column was used in a CALC expression but is
not defined in the rowset," and the part of the form I was trying to sort is
now completely blank. I'm afraid I'm not too familiar with Access, and
hopefully this is an easy fix. I think all the entries are still there
because the page numbers are there...I just can't see them for some reason.
Any help would be much appreciated.
 
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
 
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.
 
Back
Top