Subform editing error

[Joe Holzhauer]

I have a continuous subform that works just fine when it's based on a table,
but I want to base it on a query. When I change the recordsource to a query
instead of a table, as soon as I type a single character, I get the error:
"Field cannot be updated."

Also, when I try to update information in the same subform, I get the error:
"Cannot add record; join key of table 'tblEstimateItems' not in recordset."
The problem is, the whole tblEstimateItems is included in the query. I'm
just using the query to add a field from another table.

Thanks again! Joe

 

[Rob Oldfield]

If the additional field is from a subtable, then I'd guess that you're
making the underlying query non updatable. If you're using a subform, then
the base query shouldn't need to include that field.