Clearing checkboxs

  • Thread starter Thread starter Peter MacInnis
  • Start date Start date
P

Peter MacInnis

Good day, I have a table that contains questions for a
test. Colom 1 contains the questions. Colom 2 contains a
checkbox. I have a button will print all the selected
questions. What I would like to do is have a button or
when the form is closed, clear all the checkboxes and
update the table with cleared checkboxes.

Thanks in advance.

Peter MacInnis
(e-mail address removed)
250-363-1240
 
Put the following code (change the table and field names as
appropriate) in the forms close event.

Private Sub Form_Close()

Docmd.runsql "UPDATE yourTable SET column2 = FALSE"

END SUB

--
HTH

Dale Fye


Good day, I have a table that contains questions for a
test. Colom 1 contains the questions. Colom 2 contains a
checkbox. I have a button will print all the selected
questions. What I would like to do is have a button or
when the form is closed, clear all the checkboxes and
update the table with cleared checkboxes.

Thanks in advance.

Peter MacInnis
(e-mail address removed)
250-363-1240
 
Back
Top