i want to loop the number like from 1 to 3 to 4 and so on if ever i save another record in the ms access,if its detect that there are no record in the ms access then it will show 1 which is ready to the new record and if its detected that there is a record then it should loop ex:there are 2 record in the ms access then it should be loop to 3 and so on..like if its detected that there are number-5 in the last record and the number-2 is deleted so it will be(number-1,number-3,number-4,number-5) then it will loop to 6..

any help will be appreciated