Why is report re-prompting for parameters when I print?

[rebecnoel]

I have a report that opens up correctly in preview mode (after I enter in
appropriate parameters). For some reason though it asks for the same
parameters again when I try to print the report. Any idea what might cause
this?

 

[John Spencer]

When you print a report it runs the query. When you print the report from
preview it call the print routine which reruns the query.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

 

[rebecnoel]

It only does this for 1 of the 20 reports in my database though. For the
other 19 I can print directly from preview without a second prompt for
parameters. Any idea what might be different with this 1 report?

 

[John Spencer]

No. I can't see any of your reports so obviously it is difficult to tell
you what is different.

Are you getting the parameters from a form or are you just using a parameter
prompt?

Does this one report have the parameter prompt in the underlying query? Or
are the parameter prompts coming from something in the report itself?

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

 

[rebecnoel]

The parameter prompt comes from an underlying query which is linked to a
combo box on a form. The report set-up is the same as a number of other
reports so I'm really not sure where to begin looking. I was wondeing if
report properties I'm unaware of deal with printing parameters or something.

Sorry, I know it's pretty impossible to diagnose a problem without even
seeing the database. I appreciate your responses. I may need to re-create the
report to see if the same problem arises.

 

[John Spencer]

My guess is that one of the following may be the problem
-- the form is not open when you run the report
-- the form name or the control name has changed (perhaps so subtly that
you don't notice the difference)

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

 

[rebecnoel]

You are right. If I open the report in preview mode and then re-open the form
and choose the same parameter and then print, it doesn't give me the second
prompt.

What's odd is that the other reports print with no second prompt without
their respective forms being open. Maybe the difference is just the
structural differences in the reports themselves. I was hoping maybe there
was a report property that might cause this but it doesn't sound like that's
the case...

 

[John Spencer]

Well. my original response may have been offbase. I thought I recalled
earlier versions of Access doing what I said, but I've since checked and I
am not seeing the behaviour of it prompting for input parameters again if I
print from preview - at least on the lmited testing I did.


--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..