filter a 1-page report

  • Thread starter Thread starter Sammy
  • Start date Start date
S

Sammy

I use a form to select the record for a 1-page report
using a command button. The problem is that the 1-page
report prints on 2 pages, and the second page of the
report always has blank data (but headders etc. filled
in.)
Here's the code I use to launch the report preview:

Dim stDocName As String

strCriteria = "[client] = " & Chr(34) & Me!Client &
Chr(34)
DoCmd.OpenReport "WTN Statement", acPreview, ,
strCriteria

Does it have something to do with the preview mode? Can
I specify to print only page 1 in the code?

Thanks!
 
Back
Top