criteria from another query

[Guest]

Sometimes right sometimes wrong:
When I use the results from a field in a query as the creteria for a field
in a different query, I sometimes get a prompt (when I activate the query)
for a paramater criteria. I understand the bracket issues for a paramater
query. How do I tell the query that this is not a paramater query but
criteria.

 

[Ken Snell \(MVP\)]

You'll need to show us an example of the code that you're using (or the SQL
statement if it's a stored query) so that we can debug it with you. Any time
you get a parameter prompt, it's because Jet does not find the specific
field in the query's data source.