Unanswered: How to pass a parameter from a form to a stored procedure?
I am using an ADP, and I have an unbound control in a form, where a user can input a name, and I would like to be able to pass this name as a parameter to a stored procedure.
To make it as simple as possible, let's say we have the following:
1. A form called Frm1
2. An unbound text box, called TB1, in form Frm1
3. A stored procedure called SP1
4. A field in the stored procedure, called Field1, to which I am trying to pass the value of TB1, from Frm1.
I have a command button in Frm1 that opens SP1. But how do I tell it to open SP1 in such a way that Field1=TB1?
One thing I tried was to use the following code in the stored procedure:
Needless to say, this did not work. Nor did various modifications of this code. What am I doing wrong?
Any ideas would be greatly appreciated. I have been reading various sites, and a lot of people seem to be having this problem, but I can't find any solutions that have worked.