On Sun, 21 Nov 2004 15:56:37 -0500, "WWV" wrote:

I was worrking with a clients db and without going into details, they issued
2 new records in a table then I restored it. I need to put these records in
and generate 2 new records in a table with autonum field. There are 2 "open"
places for the records but I don't if it's possible to force add them and
PUT IN THE NUMBER I WANT? Can anyone tell me if this can be done?
ie. NUM existing 100 104 105 can I force 102 and 103?

By NOT using an Autonumber.

An Autonumber field has one purpose, and one purpose ONLY: to provide
a guaranteed-unique key. Autonumbers are intentionally NOT editable or
controllable. If you care what the value is, or want to see it, you
should use a Long Integer field instead, and maintain its value
manually or in VBA code.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps