Disabling a control after entering data

[chrisroy1972]

Hi everyone,

I know some basic code to disable a control after updating but, I have 20 or so controls that I want that to happen to as the record is updated over time. Is there a way to group all those controls and have them evaluated after going dirty instead of having to code each control?

Oh, and I would like the controls to become enabled if no data is present. Any help would really be great.

chris

 

[pbaldy]

You could use a loop of all controls and have something in the Tag property of those 20 to identify them. Then put your code inside a test of the Tag property inside the loop.

 

[chrisroy1972]

Thank you. would you be able to give me an example of the code to write? I would really appreciate that.

chris

 

[smig]

Dim ctrl

For each ctrl in me.Controls
If ctrl.Tag = "disableCtrl" then
Ctrl.Enabled = False
Next ctrl

 

[pbaldy]

Dim ctrl

For each ctrl in me.Controls
If ctrl.Tag = "disableCtrl" then
Ctrl.Enabled = False
Next ctrl

You would add to that a test for a value in the control, and enable/disable as appropriate.