Subform Additions Edit Deletions Properties Getting Changed

[bcooler]

I have a form (let's call it Form1) with a subform that has been working well for some time now. However, I made a new read only version of the form (Form2) that (at the form level) has the Additions, Deletions, and Edits properties set to "no". Not everytime, but I now run into cases where I try to enter data into the original form (Form1), but the subform properties above have been set to "no", preventing entry (bad). There are no VBA bugs that do anything to these properties.

My understanding is each form level control only sets the form control, not the permanent setting for any subform. Am I right? Why is my subform getting permanently modified? I really don't want to use VBA to change it everytime the form is opened. This seems like overkill.

Very confused.

 

[TheAceMan1]

How are ya bcooler . . .

When you say [blue](at the form level)[/blue] ... what do you mean? ... Otherwise your post is [blue]ambiguous![/blue]


See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[bcooler]

Sorry. What I mean is these properties are modified at the form level instead of at the individual field level.

 

[TheAceMan1]

bcooler . . .

Realize ... a subform is [blue]just another control[/blue] on a form! ... albeit a special control, but a control nonetheless. This is why it adapts form level properties just like any other control! Lock the form ... locks the subform.

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]