Click on a button must change table value

[The_Freak]

I have a table whit a field "yes/No"
The defaultvalue is set to "No"

I have a form with a button

Now when i click the button i want that the the value of the checkbox change from "No" to "Yes" automatticly. Anyone know how to do this?

 

[charityg]

If you want it to toggle the value back and forth between yes and no then I would use this procedure in the onclick event of the command button.

If checkbox=0 then
checkbox=-1
else
checkbox=0
End If