I use DoCmd.OpenReport and the Load event code gets executed. But if I use DoCmd.OutputTo, the Load event does not fire. I want that Load code to fire when I output the report without opening it.
I use DoCmd.OpenReport and the Load event code gets executed. But if I use DoCmd.OutputTo, the Load event does not fire. I want that Load code to fire when I output the report without opening it.
I don't think a "Load" event on "OutputTo" makes any sense. The "OpenReport" physically opens a report. It is that opening/loading of that Report that is triggering the "Load" event.
The "OutputTo" just outputs your data to a file, it does not open it, so there is no "Loading" going on within an Access object, so there is no "Load Event".
Ok. I was able to do what I was trying to do on the OnOpen event.