Recordset Not Updateable

[treva26]

I have a form that runs off a Query, it all used to work fine.

Then I added some fields to the query that are based on aggregates from another query.

So those are read only, but I want the other fields to still be read/write.
Is that possible?

It causes an error and says "Recordset Not Updateable"

 

[HiTechCoach]

Is that possible?

NO.

You will have to use an updateable query to modify the data. You could use a pop-up for to edit the data that has only the fields you want to change so that it is updateable.

 

[treva26]

NO.

You will have to use an updateable query to modify the data. You could use a pop-up for to edit the data that has only the fields you want to change so that it is updateable.

OK thanks.
Since there are loads of editable and only a few read only fields
I will use the original query and have DLOOKUPs for the read only fields.