print window from print preview?

[HX]

I have a small application in Access 2000 that generally hides Access from
the user. They can import data and print it in the required format. I've
just added the ability for the user to see the report before it's printed
simply by adding a button that opens the report in print preview mode, and
added a print button to my custom toolbar. Problem is, clicking the print
button defaults to printing ALL the pages - there isn't even a prompt!

How can I give the user the Print Dialog window from a report's Print
Preview page?

Access and VB aren't what I normally do, so if you're going to suggest
coding something, I'd greatly appreciate details!

Thanks much for any help in this.

 

[HX]

Well, I figured out that I could create a custom toolbar button and assign a
macro SendKeys of %P to open the print dialog, which was a step in the right
direction.

Now, however, I've realized that I can't seem to give them the Print dialog
that I WANT ... by default they are getting the one with option to print
pages FROM and TO as a range, when I wanted to use the one that gives the
option to print Current or a range such as 2-14, 21, 33. Any idea how to
get that particular print window for a report??

 

[HX]

Ooops.... I mean, runcommand / print - not %p.