ShowPrinter not printing!

[grande]

So using this code:

DoCmd.OpenReport "rptPalm_Review_e", acViewPreview
[Forms]![frmPalmSelect]![cdialog].ShowPrinter

I bring up the printer dialog box. Problem is, when I click "Print," nothing happens.

Am I supposed to put some code in to make it print, or does anyone have an suggestions?

-------------------------
Just call me Captain Awesome.

 

[RoyVidar]

ShowPrinter is a sub or function of the form? Would there be a conflict of what's selected/has focus? I think perhaps the contents of the sub or function would help in assisting.

Could using

[tt]docmd.runcommand accmdprint[/tt]

in the reports on open event do?

Roy-Vidar

 

[HarleyQuinn]

Roy - I think grande is using the .ShowPrinter method of the Common Dialog control to invoke an instance of the Printer Dialog box.

Harleyquinn
---------------------------------
Help us to help you,
read FAQ222-2244 before posting.

 

[ZmrAbdulla]

Grande, It was good if you had a ref to the thread705-1049528 in this. Easy to understand !!

________________________________________
Zameer Abdulla
Visit Me
There is only one perfect child in this world. Every mother has it.

 

[grande]

Okay, to answer your questions:

I am using the .ShowPrinter method of the common dialog.
docmd.runcommand accmdprint isn't an option because the default printer is a "Fake Printer." I don't know why, that's just how the network is set up.

How do I set the focus to a report? I tried [Reports]![rptPalm_Review_e].SetFocus
and a few variations of that, but I get an error saying
"Application-defined or Object-defined error."


-------------------------
Just call me Captain Awesome.