My SP is named InTransit.

Tried this, got same result as before, it shows all the records:

text to cmd textmerge noshow
exec InTransit ?m.fdBlNo
endtext

>>Hmm, that gave me an error saying "Could not find stored procedure 'exec InTransit'", so I took the "exec" out and then it just displaying every single record instead of only grabbing the one I put in the input box.
>>
>>I'm not sure I understand how it would work unless I could get a WHERE clause in the FoxPro code.
>>
>>>For the stored procedure it should be
>>>
>>>>

text to cmd textmerge noshow
>>>>[exec InTransit] ?m.fdBlNo
>>>>endtext

>>>
>>>Assuming your SP has just one parameter.
>
>Sorry, what is the name of your SP?
>
>Also, I forgot to get rid of the []
>
>It should be
>
>exect MySPName ?myParamName