Does anyone know?
Also, i have a simple report in BO which has a paramater. This paramter accepts a Ref No. I have code in Access that opens a spreadsheet and loops through it retrieving the Ref no. I need this ref no to be the parameter to the BO report, but it ignores the parameters I pass to it and always uses the value that the report had when it gets saved.
eg. create the report and put a value of 123 in the param. Save it and run my vba. the report always returns the record for 123. If I save the report with no value then the report always returns 0 records.
Please help! I thought I had it sussed but this problem has really thrown me.
Nick
Also, i have a simple report in BO which has a paramater. This paramter accepts a Ref No. I have code in Access that opens a spreadsheet and loops through it retrieving the Ref no. I need this ref no to be the parameter to the BO report, but it ignores the parameters I pass to it and always uses the value that the report had when it gets saved.
eg. create the report and put a value of 123 in the param. Save it and run my vba. the report always returns the record for 123. If I save the report with no value then the report always returns 0 records.
Please help! I thought I had it sussed but this problem has really thrown me.
Nick