Hello,

I'm new to Access and have just inherited a database consisting of tables, queries, subreports, and one main report. As I was updating the database I changed a field heading in a table. I've updated all queries using this field, but can't seem to find a way to update the subreport. Whenever I try to add a field in the subreport, I get the field list that existed prior to my change - the new field is unavailable.

Any words of advice?

With your subreport in design view, check the properties of the sub report. Find out the name of the table or query that runs the sub report.

It sounds as though you may have missed updating the query that runs the subreport.