Print preview with forms

[jonesy29847]

I have a form with controls to print reports, I am using print preview so I can select which printer to use. The results is the form gets printed, not the report.

Thanks for your help.

[dsmacs]

Post your code

[pdebaets]

Try this from a command button OnClick event procedure:

DoCmd.OpenReport "MyReportName", acViewPreview

[jonesy29847]

I'm using a macro.

Open Report with the following parameters:
Report Name, Print Preview, , , Normal

The report is produced, but when I select print, and choose a printer, the form prints but not the report, even if the form has been closed.

Thanks

[jonesy29847]

pdebaets no joy, thanks for suggestion, I will explore you have given me some ideas...