Parameter SP as RowSource in Combo Box

R

Richard Roche

Is there a way to use a Parameter driven stored procedure
as a row source to a combo box?

A2K won't let me assign a recordset to the control (XP
will). I've tried converting to a Value List but in some
cases i get an error that 'my property setting is too
long'.

Any ideas or work arounds appreciated.
 
V

Vadim Rapp

RR> Is there a way to use a Parameter driven stored
RR> procedure as a row source to a combo box?

If the parameter in s.p. has the same name as a control on the form (plus @),
Access will substitute.

Vadim
 
B

BJ Freeman

record source type Table/View/StoredProc
Row source dbo.ADP_Stored_Proc_name

AC2K will only show you tables and view in the wizard. So I dummy up the
view that has the same sQL as the SP.
The lets the wizard do its thing.
then when it is created and you can go into the drop down in properties
replace the View with a Stored procedure.
 

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
Change Rowsource 4
Can I use a sp w/ parameter as combo box row source? 2
syntax for exec sp w/ varchar parameter as cbo rowsource? 7
Parameter query as row source to a combo box 3
Stored procedure as row source for a combo box 4
Passing a Parameter to a Stored Procedure From a Form CBO 2
Pass parameter to sp 1

Top