VB6 and CR 9 Parameters Fields Question ?

[hanglam]

Hi. I created a report using VB6 and CR9. The report is based on a Stored Procedure on SQL Server 2000.
My stored procedure requires an input parameter.

My question is :
1. How do you update the parameter field at runtime from within Visual Basic ?
I tried this code but it does not work:

Report.ParameterFields(1).ClearCurrentValueAndRange
Report.DiscardSavedData
Report.ParameterFields(1).AddCurrentValue "2003000301"

msgbox report.ParameterFields1).GetNthCurrentValue(1)


but when I check if the value has been updated/changed I still keep getting the old value.

Any ideas ?

Thanks
Hang