[AccessD] Parameter Query asks twice

Chester
If your report's recordsource refers correctly to the form's list field as
its criteria (ie =Forms.[frmYourForm].[ctlName] ) then there should be no
prompt at all. It should just work. If you're getting prompted then you've
either got a criteria that Access can't resolve (maybe mistyped) or you've
actually listed something in the Parameters box within the report
definition. If the latter, delete it. 

Andy Lacey
http://www.minstersystems.co.uk 

> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com 
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of 
> Kaup, Chester A
> Sent: 22 January 2004 22:26
> To: Access Developers discussion and problem solving
> Subject: RE: [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/a> ccessd
> Website: 
> http://www.databaseadvisors.com 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com 
> http://databaseadvisors.com/mailman/listinfo/a> ccessd
> Website: 
> http://www.databaseadvisors.com
> 
> 
> 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com 
> http://databaseadvisors.com/mailman/listinfo/a> ccessd
> Website: 
> http://www.databaseadvisors.com
> 
>