I am using a procedure that autoincrements (like newID) a table. In this procedure the last line has "Returns lnID". When I issue an insert into table, is there a way to capture this Return variable which gives me the new id number for table? I am issuing "insert into" from form but the procedure is run as default value in table.

thanks
Nick Patel