Seeting the row source value of a list box to parameter SP

[Zirak]

Hi,
I'm trying to set the row source of a list box to a parameterized SP through code.

If I set the ro source to a SP and the parameter is the same as one of the fields in the form its OK. But if I set the row source to somthing like
Me.ResList.RowSource="dbo.SP_getResult @prm='" & intID & "'"
it won't work.
Is the only work around to have all the parameters as hidden fields in the form?

Thanks

 

[TimKThailand]

What about this?

Me.ResList.RowSource="dbo.SP_getResult '" & intID & "'"

 

[cmmrfrds]

Check this thread958-616778