Automatic check a box after a report is run

  • Thread starter Thread starter Jacqueline
  • Start date Start date
J

Jacqueline

If I run a report stating that a fee payment received
letter was sent to an applicant...how can I upon closing
that report...check a box on a form (Acknowledgement)
showing that letter was sent?

Or how can I email that applicant(s) who's fees I
received on a specific day that report and have the
checkbox checked afterwards to show it was sent?
 
Just add code in the reports OnClose property to look up your record in a
table and modify the value of the checkbox field to true.


Rick B


If I run a report stating that a fee payment received
letter was sent to an applicant...how can I upon closing
that report...check a box on a form (Acknowledgement)
showing that letter was sent?

Or how can I email that applicant(s) who's fees I
received on a specific day that report and have the
checkbox checked afterwards to show it was sent?
 
Keep in mind as you try to make this automatic that you need a way to deal with
paper jams, printer won't print, etc. The usual way to deal with this is to
pop-up a message asking the user if printing was complete. If answered Yes then
check the checkbox.
 
Ahhh. Good suggestion!


Keep in mind as you try to make this automatic that you need a way to deal
with
paper jams, printer won't print, etc. The usual way to deal with this is to
pop-up a message asking the user if printing was complete. If answered Yes
then
check the checkbox.
 
Back
Top