2ndary data source-SQL Stored Procedure

V

V. V.

I am trying to retrieve data from SQL tables to populate
a repeating table. I have a secondary data source that is
a SQL stored procedure. I need to populate a repeating
table on the form thru the stored procedure. I can
retrieve the data if I hard code an ID number, ie. (EXEC
STORED_PROCEDURE 1022), but am unable to pass the
parameter to retrieve the data based on the user request.
Any help or code(if nec) would be appreciated.
 
S

Steve van Dongen [MSFT]

V. V. said:
I am trying to retrieve data from SQL tables to populate
a repeating table. I have a secondary data source that is
a SQL stored procedure. I need to populate a repeating
table on the form thru the stored procedure. I can
retrieve the data if I hard code an ID number, ie. (EXEC
STORED_PROCEDURE 1022), but am unable to pass the
parameter to retrieve the data based on the user request.
Any help or code(if nec) would be appreciated.
Click to expand...

How to display the results of a stored procedure
http://support.microsoft.com/?id=827007

Regards,
Steve
 
Top