I have a small amount of code that will fire off a stored procedure that will add a new record to a table/recordset. This is what the Stored Procedure looks like:<BR><BR>CREATE PROCEDURE spAddRetRec<BR> @ext varchar(3) = ""<BR>AS<BR>BEGIN <BR> INSERT INTO Employees (extension) <BR> VALUES (@ext)<BR>RETURN @@IDENTITY<BR>END<BR><BR>This is supposed to return the newly created record, but how do I get at that record i.e. reference it in code so I can modify this record? As far as the syntax, and the stored procedure doing what it is supposed to, everything checks out. I just have no clue as to how I get at this record.<BR>