Hey guys,
I was wondering if it were possible to print a report after it opens in print preview but without the dialog box (and here's the kicker) while a form sub is still running.
I figured out DoCmd.PrintOut will print without the dialog box but it wont run while Access is still running a sub from a form. (It gives a Run-time error 2585: This action can't be carried out while processing a form or report event.)
The other thing I tried was putting RunCommand acCmdPrint after the open report line but that results in the unwanted print dialog box. Is there anyway to achieve this? I need the report to load in Print Preview as there is script in the onload bit of the report that needs to run in order for it to be printed correctly. Thanks ahead of time for the help.