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?

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