Query results that depend on input - Where to store.

[Homegrownandy]

I want to produce letters based on a query. The query uses a form and user input to determine which records to get. But to reference a query in word (mail merge) the database must be closed.



either I need to save query results before doing a mail merge and reference that (what would be the best way to do this?), or is there a way the database can still be open and it will do it?

[Homegrownandy]

Apparently opening it in runtime works.