Print specific page of report

[Sing]

Can you anyone help me? I have created a report (single Label) and
everytime I click print, it always print 3 addition blank labels on Seiko
Smartlabel printer. I can manual specify which page to be print from the
Print Preview, but I would like to know how can I control what page to be
print the Form Menu?

The statement below will print all pages.

DoCmd.OpenReport stDocName, acViewPreview, , "[Tracking_ID]='" &
Me.Tracking_ID & "'"

I just want to page 1.

Thanks.

 

[Arvin Meyer [MVP]]

Try:

DoCmd.OpenReport stDocName, acViewPreview, , "[Tracking_ID]='" &
Me.Tracking_ID &
DoCmd.PrintOut acPages 1, 1
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Downloads
http://www.datastrat.com
http://www.mvps.org/access