Problem printed multiple instance reports

[MJP]

I've managed to preview multiple instances of a report, all with
different filters. The problem now occurs when I try to print these
reports or export as snapshot etc. If you try to print any of the
reports it only prints the first report that was created.

Are there any workarounds for this or is this just a limitation of
access?

[Terry Kreft]

It sounds more like a limitation on your methodology.

Show us rge code your using and people may be able to help.

--
Terry Kreft

"MJP" <ma****@tiscali.co.uk> wrote in message
news:11*********************@g14g2000cwa.googlegro ups.com...

I've managed to preview multiple instances of a report, all with
different filters. The problem now occurs when I try to print these
reports or export as snapshot etc. If you try to print any of the
reports it only prints the first report that was created.

Are there any workarounds for this or is this just a limitation of
access?

[MJP]

Dim rptInstance() as Report
Dim i as integer

i = 0

DateSQL = "DeliveryDate Between #01/01/2005# and #01/06/2005#"

Set rst = CurrentDb.OpenRecordset("SELECT PatientTag.TagID,
PatientTag.TagDescription FROM PatientTag;", dbOpenSnapshot)

rst.MoveFirst

While Not rst.EOF
sSQL = DateSQL & " And HomeTag = '" & rst!TagID & "'"

ReDim Preserve rptInstance(i)
Set rptInstance(i) = New Report_DeliveryPointPCTReport
rptInstance(i).Filter = sSQL
rptInstance(i).FilterOn = True
rptInstance(i).Visible = True
i = i + 1
rst.MoveNext

Wend

All the reports print fine, but when I try print or export any of them,
only the first report prints.

[MJP]

All the reports preview fine rather