till you find out which one. Then fix or adjust.
try to copy the results of the subforms to bound text boxes.
filter for that year with all of the Where criteria.. Open the query. One of those "criterias: is stopping you from updating the record. Remove them one at a time till you find out which one. Then fix or adjust.
You may have to Dim a recordset, update the record, then requery if worst comes to worse.
Its OK, I have found the problem. Thanks for your help.
Is there a way to open a *FILTERED* recordset on an excel file ?