how to change report parameters in vba with out having to open the report

[thydzik]

i have run into the problem where I want to change parameters of a report in vba but it states I need to open the report first, which is no good.

at the moment I am just wanting to do the following

Dim r As Report
Set r = Reports("myReport")

but this only works when the report is open, is there a way to do this without opening the report.

i am actaully wanting to change the RecordSource parameter eventually, in vba without having to open the report.

thanks

 

[llkhoutx]

Use a query for the report reord source; then dynamically change/modify the query prior to opeing the report.

 

[thydzik]

thanks for the reply, might have to do that.
I also thought of using visible = false after opening a report.

pity you have to have the report opened