Enable Control according to Check Box

[fflei]

Hello.....

Does anyone know how to make a control 'enabled' only if a particular check
box is checked? Am working in Access 2002

Warning: newcomer, struggling with language, syntax etc!

Thank you,

Fflei

 

[Dan Artuso]

Hi,
You can use something like this:
Me.yourControl.Enabled = Me.yourCheckbox

Substitue your control names.
You can place this code in the form's Current event
or the checkbox's AfterUpdate (or both) event depending
on when you want it run.

 

[Rick Brandt]

Hello.....

Does anyone know how to make a control 'enabled' only if a particular check
box is checked? Am working in Access 2002

Me!ControlName.Enabled = Me!CheckBoxName

Put that code in whatever events you need. Typically you would need it in the
AfterUpdate of the CheckBox and in the OnCurrent event of the form.

 

[fflei]

Brilliant!! Thank you so much!

Fflei

Me!ControlName.Enabled = Me!CheckBoxName

Put that code in whatever events you need. Typically you would need it in the
AfterUpdate of the CheckBox and in the OnCurrent event of the form.

 

[fflei]

Thank you!

Fflei

Hi,
You can use something like this:
Me.yourControl.Enabled = Me.yourCheckbox

Substitue your control names.
You can place this code in the form's Current event
or the checkbox's AfterUpdate (or both) event depending
on when you want it run.