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
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