Clear all checkboxes?

[thekruser]

What I have:
tblPersonal
-Employee# (PK)
-Print (checkbox)

What I am trying to do:
There are times I need to print reports for one or more employee and the best way I have found to do it is to include a 'Print' checkbox in tblPersonal.



The problem:
The issue is, when I want to print, I have to manually uncheck all the boxes I had checked last time. I am trying to program a button to uncheck all. There has to be a way to do it, but I cannot figure out how.

If there is a better way to get this done, please let me know. I am open to any and all suggestions. Thank you in advance for your time and help. have a great day!

[pbaldy]

Not how I would select employees to print, but:

CurrentDb.Execute "UPDATE TableName SET FieldName = False"

With no criteria, that should set all records to False. Your method wouldn't work very well in a multiuser environment. I'd probably do this:

http://www.baldyweb.com/multiselect.htm

[thekruser]

Any chances you could help me figure out how to incorporate your idea into the attached form?

Ideally, 2 buttons would have to be added to the form: one to print everyone the current logged in user can see (non-filtered...should just be able to use the button already on there, but not positive) and one button that would open the multiselect you mentioned above.

Thank you very much for your help. I just am horrible with VBA. I am learning though.