Hi, Have you thought about going and looking in an ADO reference? Then you'd know what objCommand.Execute returns (hint: not a return value), and you'd know how to get it. If you need some code, here is an example: http://www.adopenstatic.com/faq/SprocsAndParameters.asp Cheers Ken ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ From: "Tab Alleman" <Tab.Alleman at MetroGuide.com> Subject: RE: [thelist] Calling a sproc from VB Scott Dexter wrote: > in stored proc-- > // last line > Select @retval as 'ReturnVal' There's no way VB can access the value of a sproc's RETURN SomeValue ?