auto update a checkbox after printing

  • Thread starter Thread starter L Bornhoft
  • Start date Start date
L

L Bornhoft

what code would I use to update a check box to True/Yes after a report has
printed from a filtered record?

And - very important - where do I place the code - what event procedure
would hold the code?

Many thanks,
LB
 
You could add a button to click after the pages have been removed from the
printer. The code would be something like:

Me.chkHasBeenPrinted = True
 
L said:
what code would I use to update a check box to True/Yes after a report has
printed from a filtered record?

And - very important - where do I place the code - what event procedure
would hold the code?

Many thanks,
LB
Click to expand...

LB, I assume you are printing the report via the on click event button
on a form. If that is the case after the code to print the report enter
this code:


me.checkboxname.value=-1

-1 is yes, 0 is no

Rich
 
You could add a button to click after
the pages have been removed from the
printer. The code would be something like:

Me.chkHasBeenPrinted = True
Click to expand...

Let me emphasize Duane's statement "to click after the pages have been
removed." All any Access event knows is that the information was "sent" and
that no error codes were returned; it couldn't tell if the output was a
crumpled wad of pages with every line printed on top of the first one.

Larry Linson
Microsoft Access MVP
 
Back
Top