Disabling all fields on loaded form

[jtseltmann]

I have a quick question that I am not having any luck getting past. I have a tabbed main form and check boxes on one form. If the check box if checked I want to disable all the fields on a form on another tab. The problem is that in a few cases this means 'all' the fields that can possibly have focus. On the forms that have a remaining field (one that I do not need to disable) I can simply change the focus to that field and then disabled at will. But, on a few forms there are no more controls...I keep getting the error that I cannot disable the control that currently has focus. I can't seem to shift that focus to anything else on the form, even a hidden control...

does anyone have any suggestions?
Thanks!

 

[PHV]

Why not simply disable the subform control ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[jtseltmann]

PHV,
Thanks for the tip...I had tried that but did not use the correct syntax for the 'sub form control'. I noticed my syntax immediately. However, one further question...there is no way for me to show the fields 'greyed' out is there when using this method? That is the only draw back. When you disable the field individually they become greyed out. That will cause a bit of inconsistency across my forms..I guess I may have to live with that.