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!
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!