Stored procedure as combo box row source 2

[tellytubbie]

Hi all
any one know the syntax I need ot use a stored procedure as the rowsource on a combo box and to pass in a parameter?
tia
Glenn

 

[cmmrfrds]

I don't believe you can do it with the Tabs/Properties provided in the combobox. If I remember correctly, a pass-through query is a work around.

 

[tellytubbie]

Thanks cmmrfrds - as I understand it, I can't use pass through queries in a project, aren't they just for odbc. What I was hoping for was to set my rowsource to something like

me.cbMyCombo.rowsource='exec spMyLookup @Key=12345'
or
me.cbMyCombo.rowsource='spMyLookup 12345'
or
me.cbMyCombo.rowsource='spMyLookup(12345)'

etc

thanks
glenn

 

[cmmrfrds]

Check this thread out.

Thread958-616778