Do a query that will generate multi copy of 1 report with different na

[BlackSand]

Hi,
What I am looking for is to be able to generate with 1 reports a multitudes of different copies.

Let's say I do a search by region, it will give me all the companies in that region. So now (this is where I'm stuggling) I need to click on get report to get 1 report for each company that is in that region.

I already have an array with the name of the companies that match my search I just don't know how to get a report for each of them.

Here is the code I use to get one out:

If CoopInfoReport.rsCoop.State = adStateOpen Then
CoopInfoReport.rsCoop.Close
End If

If Not (cmbCoopName = "&quot Then
CoopInfoReport.Coop CoopNom
CoopReport.Show
Else
MsgBox "Select a Coop"
End If

CoopInfoReport = my DataEnvironment
Coop = command in the DataEnviroment
CoopReport = the Report I want to display
CoopNom = the name of the Coop

Is there a way I can print an array of name...
or
just make a loop to load multiple records in one report so that I have only 1 report window open and just browse inside of that to get all the reports from that region.

Thx all, any help would be gladly appreciated.

Jim