Passing values to Query parameters

I have a Report that uses a query1. query1 then references another query2.

Query2 needs the entry of a date parameter

When running the report from an access application I want to pass a value to the query2 parameter so that the popup box does not show.

Is this possible ?

Any help would be gratefully appreciated

Thanks

Conor M Hamill

Yes this is probably possible, but we need to know more. Can you post your code or something? What is the pop-up asking for, the date parameter? If the date can be any date, how do you propose to get the parameter otherwise? Your ?? is a bit confusing.

I'm not sure it's what you're looking for, but I use this simple code all over the place to change saved queries.

Dim str_qry as String
str_qry = "select ...."
Dim qry_update As QueryDef
Set qry_update = CurrentDb.QueryDefs![NAME OF EXISTING SAVED QUERY]
qry_update.SQL = str_qry



<P ID="edit"><FONT class="small"><EM>Edited by bldnbtfl on 07/22/01 08:37 AM.</EM></FONT></P>