Your post isn't exactly clear, but if I understand, you want to get the autonumber value
which was applied when you add records? Perhaps this will help
Code:
 'after the AddNew
 rs.Open "Select MAX(Index) As Idx From tblCustomer") 'Index is the AutoNumber field
 Debug.Print rs.Fields("Idx").Value