Solved Recordset is not updatable for checkbox (1 Viewer)

[Tea]

Hello, I'm trying to solve this problemfor a quite a while and still can't find solution for this.
I have a form where in details are checkboxes (fixed, not fixed, in process,... ) placed that should be editable, but can't check any of them. Check boxes are Enabled and aren't locked. Edits are allowed on the form and the checkboxes have no vba code or macro, it's simple checkbox. Only checkbox that has a code is the fixed one where afterupdate event - it shows date next to the checkbox.
Source of form is a query created in the back-end. Could there be a problem in the back end or in the form?

 

[arnelgp]

check the Query if it is updateable.
you should create another query in the Front End.

 

[Tea]

check the Query if it is updateable.
you should create another query in the Front End.

The query is created as view in the backend. I've tried to create a query in the frontend, but the performance of query was to slow so made one in the backend. The query looks like a table in access so i suppose its not changeable in the frontend and have to update it in backend? Not sure where to look if the query is updatable or not.

 

[arnelgp]

Afaik, Views are readonly. But i recall there is a thread that say it can be made updateable.
Chk this one:

Linked view permission in Access – SQLServerCentral Forums

Linked view permission in Access Forum – Learn more on SQLServerCentral

www.sqlservercentral.com

also this one:

relinking SQL View makes it not updatable

social.msdn.microsoft.com

and this one:

UtterAccess.com

www.utteraccess.com