I have a small program for a clinic, and have a very small problem dont know how to cope with it. When a new Patient walks in to the Clinic, his account is created and an unique ID is allocated to him, that unique ID is the autonumber field. Now lets say a patient does not appear for 6 months and they delete his Account details...so there will be an empty space. To explain myself clearly, what I'm saying is: Lets say I walk into the Clinic and open an Account- and I get an ID number 64...then I stop going to the clinic and the adminstration people delete my account. So if the clinic has 2000 Patients then the ID number 64 will be empty, what I wish to do is...when a new patient walks in, it checks for empty spaces before allocating a new number and if there's any empty ID available then that be allocated to the new patient. I hope you get me right...