Queries

[Tony M]

I want to produce various forms from queries. When I
change the parameters of one query all other queries then
have the same pararmeters. Why is that...........or am I
missing something.

I.E. Looking up an Employee by name and then producing a
second query that looks up by employee number. The first
query then asks for the employee number even though I
didn't change that query.

 

[Howard Brody]

Do your other queries pull data from the query you added
the parameters to?

When a query uses another query as a data source, it has
to run the source query to get its data. The parameters
aren't applied to the second query; it's just pulling it's
date from a recordse that's already met the parameters.

Hope this helps!

Howard Brody