trying to print 2 copies of report with a different label on each

Ziggy1

Registered User.
Local time
Today, 00:38
Joined
Feb 6, 2002
Messages
462
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()

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:
Ok, I did not figure out why, other than maybe it is a 2007 thing, but I just put ="____________________________" as the control source and made the control transparent and my lines Print...so I won't worry about it...I just like to understand what was happening.
 

Users who are viewing this thread

Back
Top Bottom