filter a 1-page report

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!
 

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

Top