It seems as though you made this ID number an Autonumber data type. Autonumbers never recover a deleted reference. The only way you can affect the autonumber is by using Tools, Database Utilities, Compact and Repair.  This will only start your autonumbers over at 1 if all records have been deleted. You could create a blank table, then import your existing records from the Reports table using an append query. (If all this seems out of reach, let me know)

Another way would be to delete the autonumber field in your table, save it, then reinsert it. (If you have relationships, you'll have to delete them first)

If you give me some more information as to how you're using these report numbers, I can suggest a better way to number them consecutively.

Message Edited by abach on 12-24-2004 09:05 AM

Hi! Alan,

Thank you very much for getting back on this.

What I use this File for is for all our Address Book. It has people First, MI, Last, Address, City, State, ZipCode, Home Phone #, Work Phone #, Fax # if they have one, E-mail, and Misc Feel.\

I have others Files that I want to leave the ID along too.

Thanks,

Tom

Since it appears that the ID number has nothing to do with the contacts and how you use them, just let it as it is.

There are two reasons why I like the  ID. 1. So I can maybe go to that number right away like a reference. And the other reson is when I want to do labels I know how many to put the printer. Another words keep count of how many I have there.

Thanks 

Tom

There are other, more exact ways, of determining the number of records to print on labels. One is the record count visible in the Navigation bar on the bottom of forms and tables. The other is to use VBA code to prompt the user, before printing, with the number of labels (or sheets) to insert into the printer

I'll gladly send a snippet of code that will do this, if you desire.

Okay,

You can send this to my e-mail which I got from your name and will be sending to you in a minute.