Thanksbest is use query.
Please review this article.I am struggling to understand what makes some of my queries produce un-editable recordsets.
HiTrying to figure out how to get my main query editable when all of the underlying subforms use queries with calculated fields
ThanksIn simple terms, a query is editable if every field in the query has some unique place to go when you save it. If it has no unique destination, you cannot edit using the query.
An SQL aggregate cannot be edited because it groups records in a summary and the edit cannot change the whole summary.
An SQL with a calculated field has no place to put the calculation.
Things like that are the basis for non-editable queries.
Thanks, I found that a bit ago and ha e read it. Helps a lot.Please review this article.
Microsoft Access tips: Why is my query read-only?
List of reasons why a Microsoft Access query will yield non-editable results.allenbrowne.com
Thanks for the info PatI've always wished for a smarter query engine for Jet/ACE. It always seemed to me that If I created a query to sum a customer's open orders and joined that query to the customer table, that the fields from the customer table should be updateable even though the query was joined to a non-updatable query. But, sadly, MS thinks differently and there you have it. As the others have mentioned, if one part of a query is not updateable, then none of the query is updateable.