instead of running an insert statement you could do this

rs.AddNew
ID = rs![ID]
...
rs.Update