Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

DAP error: Column in CALC expression not defined in rowset

Status
Not open for further replies.

josephwalter

Programmer
Sep 16, 2002
80
US
I've added a textbox to the Section Header of my Data Access Page (DAP). The expression I provided in the Control Source property was obviously invalid: "Column (column_name) was used in a CALC expression but is not defined in the rowset." So I deleted the textbox. I still get the error, though.

I made multiple attempts adding/removing other calculated fields, so now I'm in pretty deep...

I get the impression that each time I add a control, Access adds a field to the query in the Record Source of the Section: qryMyQuery-CREW (the section is a grouping, by crew). How do I view and clean up the qryMyQuery-CREW record source, so that I can get passed this error message?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top