I have a report that is based on a query with many parameters (e.g. [piEnterDate]).
On the Report_Open event, after I have collected values for all of the query parameters and stored them in public variables, all I need to do now is to assign these values to the query's parameters.
What is the exact syntax to do that? how do I address this query's parameters from VBA?
I presume I don't need to go through the QueryDef object, as the query is automatically loaded by the report itself. Correct? I just need to address the parameters and assign values to them.
Thanks!
Mor
On the Report_Open event, after I have collected values for all of the query parameters and stored them in public variables, all I need to do now is to assign these values to the query's parameters.
What is the exact syntax to do that? how do I address this query's parameters from VBA?
I presume I don't need to go through the QueryDef object, as the query is automatically loaded by the report itself. Correct? I just need to address the parameters and assign values to them.
Thanks!
Mor