You don't need to move to the last record to do an insert. Aslo you need to open up a record set, pass the query "Select @@IDENTITY as ID" (save that to a variable) prior to closing the DB Connection. --- Anthony Baratta President Keyboard Jockeys