Using Access ADP to get return value from a SQL stored procedure

[Guy Kerr]

I've seen posts showing how to get a return value from a stored procedure but
I'm using Visual Studio Tools for MsOffice which allows me to simply set the
connection information and I don't need to provide it when calling a stored
procedure. I use something similar to the code below:

SQLStmt = "Exec dbo.spCRS_GetCrsNumber " & Me.DebtorID
DoCmd.RunSQL SQLStmt

Can someone please point me in the right direction to help me figure the
correct syntax to get a return value from a stored procedure?

Thanks in advance

 

[Brendan Reynolds]

Answered in another thread in this newsgroup (subject 'Compiled ADP getting
return value from SQL Stored Procedure').