I have a form that has several check boxes, each corresponding to a problem encountered in processing customer specs. For reporting purposes, I have created code that automatically sets the count to "1", whenever a box is checked.
My question is regarding changing the checked box. If a person saves a record with an incorrect box checked, they perform a search to pull up the incorrect spec. They then uncheck the incorrect box and check the correct box.
The problem is that when a previously checked box is unchecked, the count field still retains a count of "1".
Does anyone know how I can set the code so if a box is unchecked, the count field is reset to "0"?
Here is my code for setting the count to "1":
Private Sub Problem_Vendor_Error_BeforeUpdate(Cancel As Integer)
Me![Vendor_Count] = 1
End Sub
Thanks for your assistance!
IP Logged
