Open multiple report instances

yes

I don't have A2007 but it might be useful to have a look at the code you are talking about.

 'Update RMA Header Table
        Set rsRmaCount = db.OpenRecordset("Select Distinct RMAID from LocalCreditMemos where selected = true")
            rsRmaCount.MoveFirst
            Do Until rsRmaCount.EOF
                Set rsRma = CurrentDb.OpenRecordset("Select RMAStatus, Comments from RMA where RMAID = " & rsRmaCount.Fields(0) & "")
                rsRma.MoveFirst
                If rsRma.Fields(0) <> "Completed" And rsRma.Fields(0) <> "Closed" Then
                    MsgBox "RMA " & rsRmaCount.Fields(0) & " cannot be closed becuase RMA Status is not Completed."
                Else
                    If CloseRMA(rsRmaCount.Fields(0)) = True Then
                        CurrentDb.Execute ("Update RMA set RMA.RMAStatus = 'Closed', RMA.Comments = RMA.Comments + '  This RMA was Closed by " & gstrUser & " on " & Date & ".' " _
                            & " Where rmaid = " & rsRmaCount.Fields(0) & "")
                        MsgBox "RMA Successfully closed"
                    End If
                End If
                       
                rsRma.Close
                Set rsRma = Nothing

                'Open Credit Memo Request Report
                DoCmd.OpenReport "CreditMemoRequestMulti", acViewPreview
            rsRmaCount.MoveNext
            Loop
         
         

In A2003 and I presume A2007, you cannot have more than a single instance of a report open at any time.  A way around it might be to 'copy' the report to CreditMemoRequestMulti1, and CreditMemoRequestMulti2, and CreditMemoRequestMulti3 and then deleteCreditMemoRequestMulti.  In your code you could dim an integer i and  then have three copies of the report open at a given time - if that's any help.

DoCmd.OpenReport "CreditMemoRequestMulti" & i, acViewPreview

That does not work, since I do not know how many times this will loop.
I saw some potential solution by instatiating NEW objects, but I do not know how to get that to work. To date, that is the most promising direction.  Any ideas?

Why do you have to loop through records in code instead of using an SQL query to select the records on which you wish to report? If you could accomplish teh selection of records in an SQL query you could then use it as the recordsource for a standard Access report showing all the items you wish to report upon in the same (single) report instance.

If you really must use a loop-based approach, then why not use the loop not to run N reports but to populate a temporary table with the keys of the records you are selecting? You could then use an SQL query joined to the temp table keys as the source for your report...

It's a much simpler approach than trying to instantiate multiple instances of the same report object - which as far as I know is not possible to do in Access.

-Stewart

I understand what you are saying, unfortunately, the documents are business documents and need to be sent to the customer, so to pile all the data into one report is not feasilble.  

Is it intended that the user actually reviews each report??  If not,  acViewNormal should automatically get the printer going let you queue the report several times.