populate combo box through stored procedure with parameters.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
I am working on a data access project access 2000.

I have a combo box I want to populate using a stored procedure that accepts
parameters.

combo boxes have row sources but they don't have an input parameter property.
if it did it would be only 2 lines of code.
and since
comboboxname.rowsource = recordset
does not work it looks like:

I have fill a fill a recordset and then loop through it and do additem until
entire record set is finished.

is there an easier way to do this?

thanks
Chris
 
You can use a pass through query, call the stored procedure with two
parameters.
change the SQL in your query dinamicaly, and then use that query as the
source to your combo.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Control on subform / combo box requesting parameter 0
Populating Combo Box With DB Objects 3
Parameter query for a combo box using form field only works first 3
populate combo box with foreign query 1
Combo Box Question 1
Loop through table 1
Combo Box recordset problem 2
Combo in subform 3

Back
Top