Crystal XI VB6 pass a string into a textbox

[mgason]

Hi,
pass a string of text into Crystal from a textbox in VB and display it, sounds easy!
I have tried a couple of things I found here and elsewhere involving both formulas and parameters. I could not get any to work.
Could some one please tell me how to go about this step by step, BOTH in VB6 and CrystalXI.

I have wasted most of a day already.

I tried making a formula field called Code, formula was simply "@Code", added it to my report.
RecipeText.Text is the name of my textbiox in VB

Then in VB I tried
report1.FormulaFields.GetItemByName("Code").Text = "RecipeText.Text"
and several syntax variations

also tried a few variations on this
report1.FormulaFields(0) = "Code = '" & RecipeText.Text & "'"

No luck
mark

 

[mgason]

in case anyone else needs to know this was the answer

report1.FormulaFields.GetItemByName("test").Text = "'" & RecipeText.Text & "'"

where test is the name of my formula in CrystalXI
and RecipeText was the name of my text input box in VB
To be clear RecipeText.text is surrounded by double quotes, then single quotes, then double again