Re: [MSAccessProfessionals] Access report, need to pass parameters to SQL Server back end

So you've got strSQL but what do you do to change the query property?

On 07/17/2020 10:07 PM Wei Qian via groups.io <wei_qian2001=yahoo.com@groups.io> wrote:

Thanks, Crystal!  Actually, I just realized the parameter selection form is used by multiple reports, so I can't change the query and open report from the click of OK button on the form.  I guess I need to do it in the report.  The report's open event currently have a macro to open the parameter selection form, which is needed.  Now where should I put the code of changing query according to the parameter selection? "load" event?  Thanks very much!