change checkbox value to false when form closes

[keyur]

Hi

I am using a continous form and have a column of check box. When checkbox is true the value of 2 corresponding fields changes. So before the form closes when the form opens next time i want all the checkbox value to be false. is this possible?

thanks
Keyur

 

[WayneRyan]

keyur,

You can use the form's OnClose event to:

DoCmd.RunSQL "Update Table Set MycheckBox = False"

But, I really think that you have a design problem here. That is
not a REAL solution. Need more info.

Wayne

 

[keyur]

Hi Wayne, I am making a training database. I have form which will show all the training courses an employee needs to be given. now i have around 200 courses in total and they are set by WorkGroups (each employee is assigned 1). So when the employee undergoes any training, the checkbox beside the training course will be checked so that they dont have to enter the completion date and due date manually. I couldnt figure out any other way (I am new to access). can you think of any better way
Thanks