Subform locked fields

[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