Disabling a field in a form while its open

[PortyAL]

Hi

I have a form and I want to disable some fields depending on whether a check box on the form is ticked.

I've tried:

 Forms![formname].Controls(fieldname).Enabled = False

but I get an error message:

"Run-time error '2164':
You can't disable a control while it has the focus."

Any help would be greatly appreciated.

Thanks

AL

 

[RuralGuy]

You can do it in the Current event of the form *and* the AfterUpdate event of the control that disables this control.

HTH RuralGuy (RG for short) acXP winXP Pro
Please respond to this forum so all may benefit

 

[PortyAL]

Thanks

Got it sorted.

AL

 

[RuralGuy]

Excellent. Thanks for post back with your success.

HTH RuralGuy (RG for short) acXP winXP Pro
Please respond to this forum so all may benefit