I need to update status in fieldname(Check) from FALSE to TRUE
whenever I use event click,

How can I code the SQL Statement ?
I try this code:

Private Sub cmdCheck_Click()

cnMain.BeginTrans
cnMain.Execute "UPDATE tblDistribute " & _
"SET Check = 1 " & _
"WHERE DistributeID = " & txtDistributeID.Text
cnmain.CommitTrans

Data type of fieldname(DistributeID ) is Number and
Data type of fieldname(Check) is Yes/No


If anybody know please give your advise to me

Thank you so much