>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