I have a report printing form (Access 97) in which I print different
reports from. I have added a combo box that selects the number of
copies that I want to print. Here is the rub... The following is the
syntax that I use. The only problem is that I have the Database
window hidden at all times and when I hit the print command button the
report prints but the Database window becomes visible.
DoCmd.SelectObject acReport, "rptSuperBill-Blank", True
DoCmd.PrintOut , , , , Me!cmbCopies
I tried a work around using the following syntax but I not only print
the report but the report printing form also.
stDocName = "rptSuperBill-Blank"
DoCmd.OpenReport stDocName, acNormal
DoCmd.PrintOut , , , , Me!cmbCopies
My goal is to be able to print "X" amount of copies and keep the form
that I am using from printing and the Database window hidden.
Any help is appreciated. Thank you in advance,
TD