Recordset is not updateable

[hazeleyre23]

Hi,

I keep getting a message "Record set is not update able" when I try can to update my fields in access.

I have looked at many forums and I have removed the distinct, checked my has table a primary key and it does not link to any other tables, however I am still getting the error message.

The form is a subform and when I go into it i can change the fields/boxes, however when I try it through the main form it does not work.

What else could this possibly be?

thanks

 

[bob fitz]

Is the subform data related to data on the main form

 

[JHB]

I read your post like you're able to change the data when you open the subform without the mainform, check if you've some code in the mainform which change the recordsource of the subform.
Else show the record source for the main- and sub-form.
Or post your database with some sample code, zip it, + a description how to reproduce the misbehave.

 

[hazeleyre23]

the subform uses a different table to the main form.

So the main form has 3 different sub forms on it as they are all linked a different table.

Therefore my main form does not have a record source.

Yes I can update/alter the data in the subform if I open it separately to the main form.

 

[JHB]

What about the other two subforms, are you able to change the data in them when they open in the mainform?
Have you checked if you've any code running in the mainform?