Print Report from form without opening Report

JayAndy

Registered User.
Local time
Today, 19:13
Joined
Jan 13, 2016
Messages
31
Hi

I am trying to click a button on the form that Prints a Report without opening.

Below is what l have in the On Click Sub

DoCmd.OpenReport "Imports", acViewNormal
DoCmd.PrintOut acPrintAll
DoCmd.Close acReport, "Imports", acSaveNo

It works but also prints the form too, Does anyone know why and how to stop it printing the form the buttons on.

Thanks

Jay
 
Thanks tried that but still print the form
 
Did you remove the line;
DoCmd.PrintOut acPrintAll

You won't need it.
 

Users who are viewing this thread

Back
Top Bottom