Record Set Not Updatable - Runtime Error 1

[bursoni]

I'm getting this error:

"This Record Set Not Updateable" when I select a button that updates a field in the datbase. The form's data source is a "Query", if that helps.

Anyone have any idea why this might be happening and how to fix?

Brian

 

[WildHare]

This message could come about for two possible reasons: the query is a Totals Query, and is thus displaying summarized records. No updates are possible to fields in a totals query.

The second possibility is that the join the query is performing is keeping you from updating because what you are attempting to do would violate referential integrity - removing a linked value on the 'one' side when there are existing 'many' side matches, for example.

Sometimes the use of "Cascading Deletes" and "cascading Updates" can get around this, sometimes not.

Remember, you're unique - just like everyone else
You're invited to visit another free Access forum:

http://www.forumco.com/jmhare

or my site,

http://www.jmhare.com