[AccessD] Parameter Query asks twice

I really did not state the problem correctly the first time. The data
from the drop down list on the form works fine in the query. The problem
is that the SQL statement in the report asks for a date both when
previewing the report and when printing the report.

I am using Access 2002.

Thanks


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte
Foust
Sent: Thursday, January 22, 2004 4:04 PM
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] Parameter Query asks twice


What version of Access are you using?  Running reports based on
parameter queries means that you have to pass the parameters to the
query.  Does the query reference the form?  Is the form open when you're
trying to run the report?

Charlotte Foust

-----Original Message-----
From: Kaup, Chester A [mailto:kaupca at chevrontexaco.com] 
Sent: Thursday, January 22, 2004 1:23 PM
To: accessd at databaseadvisors.com
Subject: [AccessD] Parameter Query asks twice


I have a form with a drop down list on it. Once an item is selected from
the list it is used as the criteria for SQL statement that is the data
row source for a chart on a report that opens in print preview. This
work great. When I go to print the chart it asks for the criteria again.
Is there a way to prevent this and just print the report? Thanks.

No trees were killed in the sending of this message. However a large
number of electrons were terribly inconvenienced. 



_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com