469,134 Members | 1,290 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,134 developers. It's quick & easy.

multi-page, multi-filter access report problem

Hello,

this is my question --

I need to create a multi-page report. each page is about a product
selected during runtime. the number of products is also decided at
runtime.

right now, i loop thru a recordset. in each iteration, i get the field
from the recordset, and pass it as filter to openReport with
acViewNormal. but I prefer to have the report opened in preview first.
I tried to use openReport with acViewPreview. However, access doesn't
allow me to do that, giving a warning like "you can't make changes once
the report starts printing". So the report in preview has only the
first page.

I wonder if someone knows anything about this. Your suggestions are
greatly appreciated! Thank you so much!

access03

Nov 13 '05 #1
0 1276

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Mike | last post: by
1 post views Thread by CARIGAR | last post: by
1 post views Thread by Mortomer39 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.