How can I clear a checkbox field after doing a query against it.

[Guest]

How can I clear a checkbox field after doing a query against it.

I have a parts table and I allow the user to checkbox the parts they want,
then I do a query looking for all the checked parts and then add them to
another table. After I've added them to another table how can I reset all
the checkboxes back to empty ?

 

[Cheryl Fischer]

You could insert the following code at the end of your process:

CurrentDB.Execute "UPDATE [tblParts] SET [tblParts].MyCheckBoxField =
False", dbFailOnError


hth,

 

[Gerald Stanley]

Set its value to False

Hope That Helps
Gerald Stanley MCSD