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.
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.
Post your code
Try this from a command button OnClick event procedure:
DoCmd.OpenReport "MyReportName", acViewPreview
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
pdebaets no joy, thanks for suggestion, I will explore you have given me some ideas...