Check box help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to create a form for task accounting. In the form I want a check box
that when checked, it will enable the Study Hours text control and disable
the Admin Hours text control and vice versa if unchecked. I also want the
opposite text control that gets disabled to default to 0.00. Any ideas on how
to do this?

Thanks,
Mayra
 
Mya48 said:
I want to create a form for task accounting. In the form I want a check box
that when checked, it will enable the Study Hours text control and disable
the Admin Hours text control and vice versa if unchecked. I also want the
opposite text control that gets disabled to default to 0.00. Any ideas on how
to do this?

Thanks,
Mayra
Click to expand...

Me![Study Hours].Enabled = (Me!Checkbox.value = True)
Me![Admin Hours].Enabled = Not (Me!Checkbox.value = True)
If Me![Study Hours].Enabled Then
Me![Admin Hours].Value = 0.00
Else
Me![Study Hours].Value = 0.00
End If
 
Back
Top