I have a subform where only one column has the editable property set to true. All the others are set to be non-editable. The editable property for the form is set to true. The form InsertAllowed and DeleteAllowed properties are set to false, ModifyAllowed is set to true. If I run the subform from object designer I can assign values in the one editable column ok.
But (and here is the problem) if I run the mainform then all the fields on the subform are non-editable. The subform control (on the mainform) has the editable property set to true . All the fields on the subform sourcetable are set to be editable.
There is no code which might be setting the properties on the subform.
I have looked at this till my head hurts. Perhaps this is my fault for working on a Sunday. Is there some property which I am overlooking which could be causing this problem ?
Suggestion: export the main and the sub form as text and search for the text ‘editable’ to find a possible location for the change?
Other question: Could it be a permission setup problem somehow, using field permissions setup or someting like that? Native or SQL environment?