Put the following code in the form's Current event:
Me!Contratcheckbox = False
Put the following code in the checkbox's AfterUpdate event:
Me!Hourstextbox.Enabled = Not Me!Contratcheckbox
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com www.pcdatasheet.com
"yugo" <ug********@hotmail.com> wrote in message
news:fc**************************@posting.google.c om...
Hi there, i have a form with a checkbox and other field...
can u let me know what is the code for
If Contratcheckbox is check then
Hourstextbox is block(you cannot enter data)
Else
Hourstextbox can receive data
End if
i forgot it and the office help doesnt help at all and i dont have my
VBA books with me....
thx