formula help

Hi all,

I am trying to pass a string in the selection formula and I keep getting the selection error . Can anyone give ur inputs as how to assign string values in the selection formula. In crystal report i used the selection tool and was able to get the result {table1.field1}= "s" but when i try in vb6 i get this error


rptdetail.SelectionFormula = "{Table1.field1} =" & s

Guys Iam still stuck at this point, need ur inputs on this issue

thanks!

Try :
rptdetail.SelectionFormula = "{Table1.field1} =" & chr(39) & s & chr(39)