Recordset is not updateable (1 Viewer)

hazeleyre23

Registered User.
Local time
Today, 02:19
Joined
Apr 6, 2016
Messages
18
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
 
Last edited:

bob fitz

AWF VIP
Local time
Today, 09:19
Joined
May 23, 2011
Messages
4,717
Is the subform data related to data on the main form
 

JHB

Have been here a while
Local time
Today, 10:19
Joined
Jun 17, 2012
Messages
7,732
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

Registered User.
Local time
Today, 02:19
Joined
Apr 6, 2016
Messages
18
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

Have been here a while
Local time
Today, 10:19
Joined
Jun 17, 2012
Messages
7,732
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?
 

Users who are viewing this thread

Top Bottom