Modifying AllowAdditions property using VBA

[dsoderstrom]

I have a form containing a subform. I would like to change the AllowAdditions and AllowDeletions properties of the subform at run time using VBA. Based upon the value of a text field on the form I would like for the user to either be able to have full data entry capabilities on the subform (adds, changes or deletes) or only be able to scroll through the records without being able to add, change or delete. Setting Enabled to True and Locked to false does not work because they can still add or delete records. Setting Enabled to False does not work either because they can not scroll through the subfile.

 

[pbaldy]

These settings are all available through VBA, like:

Me.AllowAdditions = True

You may need to change the form reference (instead of "Me") of course, if dealing with subforms and such.