Form won't allow edits

[lawdy]

I have a proposal form which contains the main form and 3 subForms. It has a lot of stuff on it and works great. However, sometimes (for some unknown reason), it puts 'no' on the property sheet's 'allow edits'. I can change that back to 'yes' and it allow edits again (once, I had to change all subForms to allow edits). I put a button on the form with the code:

Me.AllowAdditions = True



That allows edits on the main form, but not on the subForms. That code does NOT change the main form's allowEdits to 'yes', but it is editable. The sub form's allowEdits are 'yes', even though it they don't allow edits. Any help is appreaciated.

[Missinglinq]

Hard to tell from your description. First off,

Me.AllowAdditions = True

shouldn't effect the ability to make edits.

How are you opening the Form, i.e. are you starting it from the Objects Pane or opening it from another Form? I ask because the DoCmd.OpenForm code, depending on the parameters you use, can override the way that AllowEdits/AllowAdditions is set on the Form.

If it is as truly bizarre, without rhyme or reason, as your post suggests, the Form may very well be corrupted.

BTW, if AllowEdits on the Main Form is set to No, you won't be able to edit anything on the Subforms, regardless of their AllowEdits settings. The Access gnomes consider editing a Subform to be editing the Main Form, where the Subform Controls reside.

Linq ;0)>

[lawdy]

The form is opened by a button on another form. DoCmd.OpenForm "frmProposals2" is the total code on that buttom.

It appears bizarre in that I may work all day without it happening, an then 'wham'. If this is the case, is there a fix?

I have the 'allow edits' property set to yes on the property sheet. Access sets it to 'no' when it happens.

[June7]

If you want to provide db for analysis, follow instructions at bottom of my post.

There is a reason, even if that reason is corruption. Corruption is a cause that can only be fixed by rebuilding something. Maybe just a control but can be as bad as the entire db.

[lawdy]

If you are talking about providing the entire dababase, it is 149 mb. I don't think I could ever get it down to 2 mb.

[June7]

If making a copy and removing data or extracting only the relevant objects and code and running Compact & Repair still doesn't get it small enough, alternative is upload to a fileshare site such as Box.com and post link to the file.

Is this a split design?