Unable to edit fields in a sub form

[eorosz]

Hello, I'm having trouble trying to figure out where in a subform I can't edit certain fields. I tried checking in the propert sheet in design mode to see if the edits are allowed on the table and everything looks correct but not sure. I honestly don't know how the database was built but I found an old form with the same setup that isn't locked down and can't seem to find what or where that controls it so I can duplicate in on the active subform.

[June7]

Suggest you provide db for analysis. Follow instructions at bottom of my post.

Apparently, not the same setup, something has to be different. Old form was where, in same db? You did not build newer form?

[Welshgasman]

If you cannot edit certain fields then it will not be the AllowEdits property of the form.
If not set in properties for the control, then there could be code that sets that property. Normally due to a value in the Tag property of the control.

[madpiet]

I don't think you've provided enough information to answer your question. What is the source of the subform? A table or a query? If you are using a query as a source and it has calculated columns then you won't be able to edit those. Could you please post the source of the subform (if it's a query, the SQL of the query). If it's a table, something else is going on.

[Micron]

It may be based on a query that is not editable. If the form recordsource property is shown and it's a query, open that query and try to edit it.
http://allenbrowne.com/ser-61.html

[Minty]

This is an interesting thread, as my colleague started to experience this on an existing database yesterday after doing some updates to the main form.

It was extremely strange the symptoms were as follows:

• All the subforms were set to allow edits = true, allow additions = true, data entry =no.
• If they were opened separate from the main form they all behaved perfectly.
• On the main form, they were completely locked, without additions being allowed, yet there was no code to set those attributes anywhere.
• On certain sub forms there was explicit code to unlock/lock the subform control that was also being ignored.
• Even removing that code made no difference.
• We debug.printed the properties of the sub forms on load and after the current events and they were all reporting allow edits = False, allow additions = False, despite the code to explicitly unlock them.

We spent at least 90 minutes on it, trying various "fixes" and fault diagnosis. We put it down to corruption in the end, and he's reverted to a back up and will redo the work.
I can't post an example very easily as there is a lot of proprietary data/client related info on nearly all the forms, and it would take a few hours to obfuscate it unfortunately.

O365 with recent updates - same symptoms on my machine Microsoft® Access® for Microsoft 365 MSO (Version 2412 Build 16.0.18324.20092) 64-bit