clearing yes/no field

[samer]

I wanna clear yes/no field from form, not its related record, but the field it self.
like I ll have a button running macro or query by clicking it the yes no field will be cleared. find the example attached.View attachment clear.accdb. how will it be done please.

 

[highandwild]

Is the checkbox bound to a field on the table or query?

If the value in the checkbox is changed then this will change the value in the table unless the update is cancelled.

If you need to independantly update the value in the checkbox, directly or by means of a command button then unbind it.

 

[samer]

No its not bound

 

[jdraw]

In the form and specifically the On Click event of the button, try something like

Me.YesNofld1 = ""
Me.Requery

 

[boblarson]

You can't set a yesno to "". It can have one of three states - NULL, TRUE (yes) or False (no). The sample you posted IS bound to the field. So is this sample what you want or what?