title: Assign a stored procedure return value to a VBA variable
body: <p>This should be real easy, but I haven't found a real concise answer yet. I have a very simple stored procedure in sql server that returns an integer value. All I want to do is get that return value into a variable for use in Access. </p>
  
  <p>Stored Procedure:</p>
  
  <pre><code>ALTER PROCEDURE [dbo].[out_GetNextID]
  @NextSumID integer
  AS
  BEGIN
  -- SET NOCOUNT ON added to prevent extra result sets from
  -- interfering with SELECT statements.
  SET NOCOUNT ON;
  
  -- Insert statements for procedure here
  SELECT @NextSumID = IDENT_CURRENT('Outage Summary')+IDENT_INCR('Outage Summary')
  RETURN @NextSumID
  END
  </code></pre>
  
  <p>I am using ADODB to execute the stored procedure, and I feel dumb for having to ask this, but how do I access the return value in Access after I run cmd.Execute? Thanks in advance and sorry for the lame question.</p>