Define page range during print

T

tboggs25

I have a form that is used to call up a specific record and print ONLY that
record. My problem is that it prints a blank page before actually printing
the record. I'm looking to define the page range of the printed report to
only page 1. Any help on this would be greatly appreciated. Below is the
code that I am using now:

Private Sub cmdPrint_Click()
'Print current record
'using rptCaseSheet
If IsNull(Me!CaseSheetNumber) Then
MsgBox "Please select a valid record", _
vbOKOnly, "Error"
Exit Sub
End If
DoCmd.OpenReport "rptCaseSheet", , , _
"CaseSheetNumber = " & Me!CaseSheetNumber
End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0
Show Access Print Dialog to Ask for a Printer 1
How do I show Microsoft Access Print Dialog 1
VBA - exporting serial letters to single documents 0
Printing a Range Of Records Using A Button 1
Print Current Form Record Problem ACC2007 2
Prompt For Replace in Selection And More... 0
VBA works in orignal but fails in copy of database 1

Top