my check box wont reset

[sandeep0000]

in my form i have many check boxes and when i check the boxes and click on next record, the checks dont got away how would i do this, im not very strong at access


Private Sub chkReason_not_Aided_AfterUpdate()
If chkReason_not_Aided = True Then

Me.Reason_not_Aided = -1
Else
Me.Reason_not_Aided = 0
End If
End Sub

 

[sandeep0000]

i did set the control source of the check box to reason_not_aided

how do i bind my checkbox to the bootlean field

in properties the name is chkReason_not_Aided
and control source is Reason_not_Aided\

still didnt seem to work

is my code in code builder right?

Private Sub chkReason_not_Aided_AfterUpdate()
If chkReason_not_Aided = True Then

Me.Reason_not_Aided = -1
Else
Me.Reason_not_Aided = 0
End If
End Sub

 

[Remou]

Get rid of the code.

 

[sandeep0000]

thanks for all your help it worked

im a crystal reports and sql guy,
but there need a form in access for entering data. im not that strong in access

i really appricitate it, and thank you for being very patient with me, s