OpenReport

[stealth]

Can someone help.

I have a menu form with command buttons on it. I have placed code ont
one of the buttons to open a report. However I would like to previe
the report before printing, upon clicking the button the reports start
printing. How can I change this. I can't find the property to tur
off.

thank yo

 

[Steve Schapel]

Stealth,

DoCmd.OpenReport "NameOfYourReport", acViewPreview

 

[stealth]

Thank you, but I the report is presented behind the menu. What do
need to select to revert the report to the front of the window and th
menu behind?

cheer

 

[Steve Schapel]

Stealth,

It could be that the "menu" is a form with its Modal property set to
Yes. I think it might work if you add a line like this...
DoCmd.SelectObject acReport, "NameOfYourReport"
.... to the code that opens the preview of the report.