Editing with SubForms

[FunGuy]

I am using a form where I disable editing and use a command button to allow editing. But it only allows editing in the main form and not in the subform. When I try a similar button in the subform, it says it does not recognize the AllowEdits property as an OLE object. Another related problem is that I cannot use or toggle the EDIT button to disable editing again in the main form. I am using a macro to change the AllowEdits property. So how can I more effectively allow and disallow edits in Forms and Suborms?

 

[elizabeth]

Just curious what is the point of using a button to allow or disallow editing? It doesn't seem like it would provide any security against inappropriate changes, so what are you trying to accomplish?

 

[FunGuy]

It is not so much a security issue as an accidental or inadvertant edit we are trying to avoid. Pushing a button to edit is an extra step people have to go thru to make them aware they are in an edit mode and to be careful -- and to get out of the edit mode when they are done. It's a throwback to how the original Paradox DB was set up way back when and folks are used to it so I am trying to duplicate it in Access. And in Paradox it was much easier to do this since it was inherent in how it operated, you just had to push F2 and F9 to toggle between the two states.

 

[elizabeth]

Are you referring to the subform correctly - via the parent name? Forms!MyMainForm!MySubForm.AllowEdits=True<br>
<br>

 

[FunGuy]

Yes, I tried the full name with the same results -- it does not recognize it as an OLE object. It seems to interpret the third item in the list as a field name and not a form name.