Charlotte Foust
cfoust at infostatsystems.com
Thu Jan 22 16:04:18 CST 2004
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