Subform recordset is not updateable

[Derek]

Hi ALl

I have few subforms within a form. My other subforms are working fine except one. When I try to make some changes in the subform like adding something in the textbox or selecting optionbutton thn it doesn't do anything and a message "Recordset is not updateable" comes up in the taskbar in the bottom on the left hand side of the of the screen .

ANy idea why its happening?

Thanks

 

[plog]

Sounds like the subform is bound to a query with a JOIN in it. You should only base forms that directly interact with data (edit/add/delete) on tables and not queries.

I would change the recordsource of the subform to a table.

 

[Derek]

But my other subform is working fine and it is based on the same query

 

[plog]

might be the parent/child relationship you have between the form/subform that makes it unable to update.

 

[Derek]

ok. I will check. Thanks

 

[JHB]

Else show the Record source both for the none working form and for one of the other.

 

[kiwipeet]

Ensure you have the primary key defined correctly.

edit: I recall getting errors like that when connecting MS Access to SQL Server. This was resolved by ensuring the primary key was defined either n SQL server itself or in the linked table manager. (I can't recall which.)

From memory just having a unique key isn't sufficient. it needs to be explicitly defined as the primary key.

 

[kiwipeet]

Is it access only? Or connecting to SQL Server?

 

[Derek]

it is only access. I am not able to update records. My recordset for the subform is linked to a query(which is using 3 tables).

 

[JHB]

... My recordset for the subform is linked to a query(which is using 3 tables).

The link gives you an explanation of why some recordset isn't updateable.
http://allenbrowne.com/ser-61.html