L
ldiaz
Hi all community.
I have a Report, where I print information about Purchases Orders, the form
where I push the botton has a Subform with Product details,also this has a
filter to print only the Order that my form has opened,,all is working fine
but I want to make the following.
I want that at time to push the botton appear the sheet as "Print Previous"
and a Litle message with YES or NOT option, If I select OK, the print it, if
I select NOT then cancel the operation.
pease see the statements that I have :
--------------------------------------------------------------------------------------------
Private Sub printreport_Click()
On Error GoTo Err_printreport_Click
Dim stDocName As String
stDocName = "Orders"
DoCmd.OpenReport stDocName, acNormal, "InvoicesFilter"
Exit_printreport_Click:
Exit Sub
Err_printreport_Click:
MsgBox Err.Description
Resume Exit_printreport_Click
End Sub
--------------------------------------------------------------------------------------------
can someone help me please..
Thanks
ldiaz
I have a Report, where I print information about Purchases Orders, the form
where I push the botton has a Subform with Product details,also this has a
filter to print only the Order that my form has opened,,all is working fine
but I want to make the following.
I want that at time to push the botton appear the sheet as "Print Previous"
and a Litle message with YES or NOT option, If I select OK, the print it, if
I select NOT then cancel the operation.
pease see the statements that I have :
--------------------------------------------------------------------------------------------
Private Sub printreport_Click()
On Error GoTo Err_printreport_Click
Dim stDocName As String
stDocName = "Orders"
DoCmd.OpenReport stDocName, acNormal, "InvoicesFilter"
Exit_printreport_Click:
Exit Sub
Err_printreport_Click:
MsgBox Err.Description
Resume Exit_printreport_Click
End Sub
--------------------------------------------------------------------------------------------
can someone help me please..
Thanks
ldiaz