hi there,

i have a form with a button calls some code to open a report. i want to make it the printing event only happens once per record and if the user need 2 print the same data, he has to go to the second record,each time the next record chosen,i want accumulate the event and store it in a table as a sequence number. this sequence number will reset every 7 days. how do i do that?

Private Sub cmdPrint_click()
On Error GoTo Err_cmdPrint_Click

   DoCmd.OpenReport "rptlabel1"acViewPreview , ,"[LotID]=" & Me!LotID

Exit_cmdPrint_click:
Exit Sub
Err_cmdPrint_click:
MsgBox Err.Description
Resume Exit_cmdPrint_click
End Sub


tasha

__________________
tasha