I have the following code in my form:
Private Sub SaveReport2_Click()
On Error GoTo SendObject_Error
DoCmd.OutputTo acOutputReport, lstReports.Column(1), acFormatSNP, lstReports.Column(3), False
If Err.Number = 2501 Then
MsgBox "Action Canceled.", vbInformation, "Notice!"
The unbound box listing my reports on the "Row Source" is a query called "qryReportsList".
The label on the unbound box is "lstReports"
This worked in 2003, but no longer works in 2007
Once the report is selected, it needs to run before it's saved because it has parameters built in. I get a save as popup window, which is not what it used to do.
Anyone have suggestions?