Enable Control according to Check Box

  • Thread starter Thread starter fflei
  • Start date Start date
F

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
 
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.
 
fflei said:
Hello.....

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

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.
 
Brilliant!! Thank you so much!

Fflei

Rick Brandt said:
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.
Click to expand...
 
Thank you!

Fflei

Dan Artuso said:
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.
Click to expand...
 
Back
Top