Set up a passthrough query. In the View, Properties tab you put in an OBDC connection string something like this:
ODBC;Description=DSI Inventory;DRIVER=SQL Server;SERVER=DEV02;UID=test;PWD=test;DATABASE=dsi
The query itself would be something like:
Execute USP_CustRptSectionsIUO '00004041802', 1
To change the parameters, we do it through the code on the form or in a module, thus rewriting the definition of the query like:
Dim db As Database
Dim qry As QueryDef
Dim strSQL As String
Dim numProposalNumber As String
Dim qrySections As QueryDef
Dim intReportNumber As Integer
Set db = CurrentDb()
If FormLoaded("frmClientReports"

Then
intReportNumber = Forms!frmClientReports!cboReportList
Else
intReportNumber = 1
End If
numProposalNumber = Forms!frmProposal!subfrmProposalGeneral!ProposalNumber
strSQL = "Execute USP_CustRptSectionsIUO '" & numProposalNumber & "', " & intReportNumber & ""
Set qrySections = db.QueryDefs("ViewRptSectionsIUO"

qrySections.sql = strSQL
Hopethis helps.