UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> Sub Reports With Parameters - Prompt For Printing, Office 2010    
 
   
karenedmonds
post May 30 2012, 08:42 PM
Post #1

UtterAccess Veteran
Posts: 312
From: Melbourne, Australia
Hi there.

I have a report with two sub reports.
The sub reports are designed to prompt for parameters (date range).
Unfortunately it has to prompt for the range twice to bring up both sub reports.
The resulting report displays correctly, however when the print control is used (macro to Print Object), it continually prompts for the parameters.
I gave up after about 10 parameter prompts and cancelled.

Can you head me in the right direction here? Thanks.
Go to the top of the page
 
+
theDBguy
post May 30 2012, 08:46 PM
Post #2

Access Wiki and Forums Moderator
Posts: 47,992
From: SoCal, USA
Hi,

One way would be to use a Form reference for the parameters.

Just my 2 cents... (IMG:style_emoticons/default/2cents.gif)
Go to the top of the page
 
+
karenedmonds
post May 30 2012, 09:47 PM
Post #3

UtterAccess Veteran
Posts: 312
From: Melbourne, Australia
Thanks DB.
But I'm afraid I don't know what that means.
Can you head me in the right direction?
Go to the top of the page
 
+
theDBguy
post May 30 2012, 10:32 PM
Post #4

Access Wiki and Forums Moderator
Posts: 47,992
From: SoCal, USA
Hi Karen,

Check out this tutorial from Bob's website: How to use a form reference as criteria in a query.

Hope that helps...

Just my 2 cents... (IMG:style_emoticons/default/2cents.gif)
Go to the top of the page
 
+
« Next Oldest · Access Reports · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 22nd May 2013 - 12:48 PM