Parameter SP as RowSource in Combo Box

  • Thread starter Thread starter Richard Roche
  • Start date Start date
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.
 
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
 
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.
 
Back
Top