Print Preview Hangs

[ellenl5974]

I have created a bunch of reports in Access. When I click on the little print preview button on the lower right-hand side, the preview displays quickly. However, if I insert a button with the following as the code:

Private Sub cbPrint_Click()


DoCmd.RunCommand acCmdPrintPreview




End Sub

... then the preview pops up, but Access seems to hang for about 3 minutes before I am able to do anything else. Is this the wrong code to use?

Thanks,
Ellen

[June7]

The report is already open in ReportView and you want to use code on form to switch to PrintPreview. I've never done this. I just don't have reports open to ReportView, always PrintPreview or straight to printer. I use forms for on-screen presentation of data.

Review: http://www.accessruncommand.com/codeex/54.htm

[ellenl5974]

Thanks for the reply! I am using a reportview because I want to user to be able to filter and sort on the fly. Still not sure why it hangs. Anyone else?

[June7]

You want user to be able to filter and sort report after it opens? Never set that up.

The link shows code to set focus back to the report. Maybe that will make a difference.