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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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 ?
 
You could insert the following code at the end of your process:

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


hth,
 
Back
Top