[Naresh Rohra]

I had developed an application for Grocery Shop in which I have used DataReport for printing the Receipt. In which after showing the report (receipt) the updations are made in database. But, I want to set a condition that if user does not print the report the bill should not be updated. Hence I need some event to know that gets activated when user clicks on print button or when printing is complete or like that so I can set a flag for updation.

Thanks.
Naresh Rohra.

[Keithuk]

Just make a PrintReport flag.

Dim PrintReport As Boolean

Private Sub Form_Unload(Cancel As Integer)

If PrintReport = True then
SaveReport
End If

End Sub

Private Sub mnuPrint_Click()

PrintReport = True

[Naresh Rohra]

Thanks there,
But ur idea was already tried by me in fact with QueryUnlaod Event. But even though when i print the page the report doesn't closes. So, after printing also i have to close the window.

The actual event to use is 'Asynprogression'. When documetn is being printed this event gets trigered for some reason. I wonder y ... well who cares i got my problem solved

Thanks.
Naresh