Disable all controls on a form.

[Floyd Forbes]

Is there a way to disable all controls on a form when the form is open?

Floyd

 

[Allen Browne]

Setting the form's AllowEdits property to No effectively disables all
controls.

If you want to loop through the controls and disable only the bound ones,
grab the code in this article:
Locking bound controls on a form and subforms
at:
http://allenbrowne.com/ser-56.html
The code calls itself recursively so that any level of subform is handled
also.

 

[BruceM]

Do you get what you need if you set Allow Edits, Allow Addititions, and
Allow Deletions to No in the form's properties?

 

[Floyd Forbes]

Thank you.

Do you get what you need if you set Allow Edits, Allow Addititions, and
Allow Deletions to No in the form's properties?