Subform locked fields (1 Viewer)

[Joy83]

Hi
I have a subform container in a main form.
That subform is locked I can’t edit the fields.

After investigations, I found that the reason why I can’t edit them is because I am using a subform to read a query that uses sql join.

I still need to use that subform and edit it. Is there any other way around?

 

[CJ_London]

sometimes, changing the subform recordset type to 'dynaset - inconsistent updates' will work.

Otherwise provide the sql to the subform - perhaps you don't need the joins and can use combo's or another subform instead

 

[Joy83]

I changed it to dynaset
And it worked
Many thanks

 

[Pat Hartman]

I found that the reason why I can’t edit them is because I am using a subform to read a query that uses sql join.

Joins do not in and of themselves make a query not updatable. I have queries with 20 joins that are updateable. Your join is invalid. It may be producing a Cartesian product because you have two 1-m relationships that are parallel but don't result in a hierarchy. The change in property to "inconsistent updates" is a band aid. It tells Access to ignore the improper join.

You will find that the query, if run by itself, will not allow updates. It has nothing to do with being bound to a form.