I have a Report that is opened from a Form. The Form has 15 sub-Forms on it and the Report has 12 sub-Reports. If I try to Print the Report (the Form remains open) I get a message box telling me that I cannot open any more databases. The Report will Print, but the data for the sub-Reports is missing.
To get around this issue, I’ve put a “Print” cmdButton on the Form which Prints the Report without the error messages and the sub-Report data is shown.
The users of the From/Report are OK with this setup except that they want to be able to have the Print Dialog box show up so that they can chose the number of copies to Print.
I’ve tried using DoCmd.RunCommand acCmdPrint which opens the dialog box, but it Prints the Form and not the Report. Is there any way to call the dialog box and set the object that it will print?