sending value in VB to Formula in Crystal Report 8.5

[Wen Lie]

holla...

wrong room perhaps... but pls help... since I know this room will reply faster that other.... and I need this help soon.

I have a .RPT file which have an empty formula.
if you ask why empty formula ? coz, I'll send a value to this empty formula from my VB project.

PS : only 1 formula exist in that .RPT file

let's say this empty formula name = "period"

and I have a text box object, name = "txtPeriod"

what i need to do is to send txtPeriod.Text (in VB) to formula "{period}" in Crystal Report.

I did as below, but error.....

Dim CApp As New CRAXDRT.Application
    Dim CReport As CRAXDRT.Report
    Dim myPeriode as String
    
    Screen.MousePointer = vbHourglass
    
    Set CReport = CApp.OpenReport(App.Path & "\myReport.rpt")
    
    CReport.DiscardSavedData
    CReport.PrinterSetup (0)
    myPeriode = "As Of : " & Format(cDate(txtPeriod.Text), "mmm-yyyy")
 
     'error occured at below line
    CReport.FormulaFields(1).Value = myPeriode

any help ?
pls...

thx a lot,
[-w-]