By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,105 Members | 1,048 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,105 IT Pros & Developers. It's quick & easy.

multi-page, multi-filter access report problem

P: n/a
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
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.