Check box help

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
 
S

Stuart McCall

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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top