cbo boxes, stored procedures and input parameters

[jebushatescats]

Hello all

I have stored procedure that I use to bring back a list of employees.
this procedure is used at 2 different instances in my app.
1 to populate fields on a form
2 to add employee names to a combo box on a different form

I have altered the stored procedure to return a list of employees based on a their supervisor code.
To do this on the form I just setup a input parameter to be equal to a supervisor code. The input parameter is passed to the stored procedure and a limited record set is create.

Ok so that works but my problem is that I have this combo box that is populated with data(employee names) from this stored procedure but I can not figure out how to set the input parameter so that a value will be passed to stored
procedure so it can execute and return values for my combo box


Am I making any sense?
any thoughts ?

 

[Crowley16]

use the adodb.connection and adodb.recordset objects to execute the stored procedure and collect the data, then directly set the recordset to the control...

--------------------
Procrastinate Now!