DoCmd.OpenStoredProcedure with Parameters

  • Thread starter Thread starter Arun Subramanian
  • Start date Start date
A

Arun Subramanian

Hi,
I am trying to use the DoCmd.OpenStoredProcedure to open a stored procedure
with the parameter from the FORM.

Like..

CREATE PROCEDURE MyProc (@MyID INT) AS

SELECT * FROM Temp WHERE ID = @MyID

RETURN
GO

From the Screen, I will be getting the ID as the user selection and I have
to open it in the view of the command button CLICK.

DoCmd.OpenStoredProcedure "MyProc " & Form!ctlList.Value, acViewPreview,
acReadOnly

Any help??

Thanks,
AS
 
Back
Top