Sudden "Record Set Not Updatable" - Form

[JHMarshIII]

Where should I begin looking to fix this problem?

I have a complex form that is one main and four sub-forms. I have been using it for data entry into several related tables for some time now.

I made some changes to one of the underlying queries and/or tables. But I can't see to remember what I did. Now the form no longer works, returning an error of "recordset not updatable".

What should I look at first? Referential integrity? I did notice that there are some records in the underlying table of the main form that do not have related records existing in the related table in the subform.

The main form's dynaset property is set to inconsistant updates. The last changes I recall making where in the area of joins within a query.

Where should I begin looking?

 

[jimbrooking]

Suggest you look at Access's online help. Search for "updatable". There arre any number of things that can cause a query to become not updatable, and it sounds like you inadvertently implemented one of them.

Not very helpful, I guess.

Jim

 

[JHMarshIII]

I did look at this help area, no luck. I will look again.

 

[Rich]

Go back to each query/subform , see if it's updateable on it's own, you should be able to track down the culprit.
HTH

 

[JHMarshIII]

Phew! That did it. It was a third table I added to the query at a later date in error.

Thanks!