thanks for answering back Yuri. What if another user inserts info right after me, will I get the wrong ID? Are there other alternatives to capturing primary key inserted into tables through forms?

thanks
Nick Patel

>Why not just:
>?table_name.lnID_field
>
>>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