clearing yes/no field

samer

Registered User.
Local time
Tomorrow, 02:31
Joined
Jan 27, 2004
Messages
38
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.
 
Last edited:
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.
 
No its not bound
 
In the form and specifically the On Click event of the button, try something like

Me.YesNofld1 = ""
Me.Requery
 
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?
 

Users who are viewing this thread

Back
Top Bottom