Thanks a ton, it worked that way but only to an extent. <BR>It returns my Identity Int but the 1st record of my database not the last one that I just inserted If I add rs.Move last to my code it works...kinda wonky if I insert and my ID is 90 it shows it 89 and when I refresh in obviously inserts another value in the DB and shows the ID as 91... so it basically misses out on the one just inserted and takes the second last one and when I refresh it gives the correct one but keeps on adding to my database. How do I correct this?