change checkbox value to false when form closes

keyur

Registered User.
Local time
Today, 04:16
Joined
Jun 22, 2004
Messages
41
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
 
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
 
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
 

Users who are viewing this thread

Back
Top Bottom