On Wed, 24 Nov 2004 09:32:18 -0800, Tim Ferguson
wrote:

John Vinson wrote in
:

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.


To be fair, John, I read the OP message as wanting to restore two records
that had been accidentally lost. If the autonumber has been propagated onto
other records (eg paper forms, remote database, spreadsheet etc) then it's
reasonable to want to put them back as they were. It's not necessarily a
cosmetic don't-want-gaps-in-the-numbers scenario.

Good point Tim! I wasn't thinking the question through and just
dropped into autopilot.


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