Count ticked in check box and displaying in a text box?

[adanoob]

thanks guys i've done it.. and 1 more question.. how do i enable 1 or 2 textbox when the checkbox is selected? when its not selected then disable the textbox... thanx millions~

 

[dbDamo]

Place this code in the BeforeUpdate event of your CheckBox:-

If Me.CheckBox = -1 Then
Me.ControlName1.Enabled = True
Me.ControlName2.Enabled = True
Else
Me.ControlName1.Enabled = False
Me.ControlName2.Enabled = False
End If