Clear contents ofg a field after ticking a check box

[David Sullivan]

I have a list of records created via a query which pulls
out all records with todays date as the due_date to
action on them,

All this is shown with in a form, I have also created a
Check box where after I do any updates required i want to
be able to tick this check box and it will clear the
Due_date of any value, what is the command for doing
this,

 

[Guest]

-----Original Message-----
I have a list of records created via a query which pulls
out all records with todays date as the due_date to
action on them,

All this is shown with in a form, I have also created a
Check box where after I do any updates required i want to
be able to tick this check box and it will clear the
Due_date of any value, what is the command for doing
this,
.
Can it be done by ising something like the following

code, if click14 = true then due_date isnull