Change RecordSelectionFormula and Refresh

[Bitaoo]

Hello,


I am using CR 9 and VB6. In my VB6 code I have CR viewer.
I set RecordSelectionFormula when the forms come up for the first time and show the report to the user. There is a drop-down in this form that user can select form, so whenever user change the drop-down, I change the RecordSelectionFormula and RefreshEx(True) the viewer but I don't know why sometime the report doesn't refresh correctly and shows the old data.
I have this code:

dim rp as new CRAXDRT.Report

rp.RecordSelectionFormula = SQLCondition
rp.DiscardSavedData
if CRViewer.Visible = False then
CRViewer.ViewReport
end if

CRViewer.RefreshEx(True)


Please Advise. Thanks
--Bita