Uncheck checkboxes

G

Guest

I have a form based on a table with checkboxes to mark which customer report
should be printed.
I would like that, after the report was printed, all checkboxes will uncheck
themselves automatically.
Is that possible and if yes, how?
Thanks
Klaus
 
P

pietlinden

I have a form based on a table with checkboxes to mark which customer report
should be printed.
I would like that, after the report was printed, all checkboxes will uncheck
themselves automatically.
Is that possible and if yes, how?
Thanks
Klaus

update the underlying record

UPDATE sourcetable
SET MyCheckField1=False,
MyCheckField2=False,
....
WHERE RecordID=Forms!MyOpenForm!txtRecordID;

or set them all to false in teh form....
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top