Enable a check box after printing

[nukephysicist]

Hello,

I have been assigned to maintain a database that was designed in Access 97', but has since been converted to 2007. What I have been asked to do is to put a check box on a report showing what active reports have been printed out. This is needed for easier tracking of active or terminated safety permits. Below is code used for printing buttons:

Private Sub PRINT_Click()
Dim DocName As String
DocName = "RWP"
Visible = False

DoCmd.OpenReport DocName, A_NORMAL, "SELECT RWP"
DoCmd.OpenReport DocName, A_NORMAL, "SELECT RWP"



End Sub

What code do I need to insert and would it go before the End Sub?

Any help appreciated.

Thanks

[NTC]

printed out? well what you are really going to record is that the print button was clicked on - - - whether or not it printed, ran out of ink or paper or whatever only a human would know.......

you need a field to record this; probably just a yes/no field unless you want the date/time.... so that when the print's command button is clicked you manipulate the value of this field.

Hope it helps.