I’ll explain what I want to do,so if there is a better way, please let me know, otherwise maybe explain what is wrong with what I have.
I’m printing 2 copies of a report, I want one copy to say “Original” and the other to say “Carrier copy”
I simply used the Printout command and referred to the report control after it opens ( doesn’t work if I put before)….so this part works…but I have controls on my report that are Unbound, and are simply used for “LINES”, they also have labels…the Labels will show, but the Textbox they link to don’t…if I just do a normal ….. DoCmd.OpenReport stDocName, acViewPreview they will print?
** Access 2007 SP2
***this is the button on the form
Private Sub Command12_Click()
I’m printing 2 copies of a report, I want one copy to say “Original” and the other to say “Carrier copy”
I simply used the Printout command and referred to the report control after it opens ( doesn’t work if I put before)….so this part works…but I have controls on my report that are Unbound, and are simply used for “LINES”, they also have labels…the Labels will show, but the Textbox they link to don’t…if I just do a normal ….. DoCmd.OpenReport stDocName, acViewPreview they will print?
** Access 2007 SP2
***this is the button on the form
Private Sub Command12_Click()
Code:
Dim stDocName As String
stDocName = "bol"
DoCmd.OpenReport stDocName, acViewPreview
Reports![bol]![txtCopyName] = "ORIGINAL - CLIENT COPY"
DoCmd.PrintOut acSelection, , , acLow, 1
DoCmd.Close
DoCmd.OpenReport stDocName, acViewPreview
Reports![bol]![txtCopyName] = "CARRIER COPY"
DoCmd.PrintOut acSelection, , , acLow, 1
DoCmd.Close
End Sub
Last edited: