Setting Query Parameters From VBA OR Form Fields

[kd2017]

I have a main parameter query that pulls together 7 other paremter queries. Several of these 8 queries require the same 2 parameters. I have need to use this query as a recordsource for a subform, and also as a recordsource for a report. The report can be called from many places in the application. I'd like to be able to open the report without requiring that a specific form having to be open when I open it. I'm thinking that I have to copy all 8 of my queries and modify them to use form Fields as parameters. But now I would have 16 queries doing almost the same thing, almost feels like a redundant waste of space. If I have a query that looks up 'parameters' from an open form is there a way to call that same query from VBA and set those form variables the same as I could set actual parameters variables from qdef?



I know how to make queries that use Fields from open forms as parameters.

I know how to use VBA to pragmatically set parameters before opening the query.


Just had a thought... Maybe the queries do use a form Fields for parameters and when necessary I can open a form hidden then open the report for the user to view. Can you open a form hidden?

[moke123]

Can you open a form hidden?

yes, look at the window mode argument for the docmd.openform method.
https://msdn.microsoft.com/en-us/vba...-method-access