I have a form which allows users to create a report by specifying various criteria to be included/excluded. The report is then created using "docmd.openreport" using a where condition based on the users selections. I would like to print the where condition on the report for reference and cant quite work out how.
I have tried the following code
"Reports!rptmemberinfopublic!txtSQLString = strSQL"
( txtSQLString being the name of the text box on the report and strSQL being the where condition string ) but I believe that as the report has already been created it won't work.
Any suggestions?
I have tried the following code
"Reports!rptmemberinfopublic!txtSQLString = strSQL"
( txtSQLString being the name of the text box on the report and strSQL being the where condition string ) but I believe that as the report has already been created it won't work.
Any suggestions?