Error with Crystal Reports

[LennyW]

In my vb code, I am building a selection formula then setting the selectionformula property. When I try to run the report, I get an error from Crystal (#20510) which says "The program cannot add the formula name you specified". I take the exact string that causes the error and paste it into the record selection formula builder in crystal and run the report with no errors. Using vb6 with crystal 7. I feel the solution is there and I am just not seeing it. I would appreciate hearing some suggestions from anyone who has had similar problems.

[delker]

Maybe what you should use is the ReplaceSelectionFormula method, eg:

CrystalReport1.ReplaceSelectionFormula NewSelectionFormula

[LennyW]

After I posted this, I happened to find the replaceselectionformula method and tried it... it was the end of my work day, so going to finish it tomorrow... i will let you know if that did the trick. Thanks