Query Filters

[AJOLSON]

I am using a form to filter on a query Named ProductionDateQur. And I have
that working perfectly.

I am using The filtered ProductionDateQur to create another Query Named
MinimumDatequr where the Minimum date is determine.
The Problem is this. Once I have filterd ProductionDateQur to the dates I
want it does not pass those results on to the subqurery named
MinimumDatequr. Consequently I get the minimum date of All records and not
the filtered minimum date that was filtered on in ProductionDateQur.

So how do I get a filter in one query to apply to another query. or to a
sub query of that query?

 

[Lord Kelvan]

what you should do it set query1 as a paramater query so rather than
using a filter you set the parameter in the query to read a variable
in the vba code and then you can just use the requery command to
update query1 and query2 when a new date is selected for more
information try posting in microsoft.public.access.forms or formscoding