Printing Letters

[djeverett01]

I need to print letters to our employees, but I only need to print the letter once. I placed a checkbox on the form of the employees to send the letter to. This will print the letter, but what i need to do next is update a field showing the letter the date was printed and then clear all of the checkboxes on the forms. That is so I can look back and see what date a letter was printed for an employee and that they only receive one letter. Does anyone have any idea on how to do this. Please help.
Thanks.

 

[JoeMiller]

After you print the letters, run an update query that puts in the date using the Date() function as your update to value. Set the criteria to only do it on people with the check marked. Then run another update query to set the checks to false on records where it's true.

HTH Joe Miller
joe.miller@flotech.net