Multiple-use Query

[Rehnahvah]

Hello Forum,

Right now I have a query that filters data based on unbound fields on a form using criteria in the format of "[Forms]![Form1]![Field1]" and it works fine.

I have multiple forms that all have the unbound fields (named the same on each form). Is there a way to have the query to filter by the data from the active form, so I can have one query that can be used with any form (instead of having a 1:1 query-to-form ratio)?

Thanks in advance!
Rehnahvah

 

[ajetrumpet]

Maybe you could drop the query and just use the .filter property in VBA??