How to make a custom autonumber?

[AccessThis]

Hi, I was wondering if there is a way to have a more dynamic auto number system.

I basically want to enter invoice numbers, but usually the invoice numbers are successive i.e. 5243, 5244, 5245

But sometimes there will be a jump such as 6667,6668,6670, ect...

So I was wondering if there is a way to build an autonumber system that tries to auto complete the next number for you based on the initial number, so say if I typed 7000 as an invoice number and went to the next record, I would want the next record to fill in 7001 for me unless I go and manually change it to something else.



Is it possible to change the autonumber system built into access in order to accomplish this? Thanks for the help!

[pbaldy]

An autonumber field will skip numbers under certain circumstances (user starts to add a record, escapes out). There are some thoughts here:

http://www.baldyweb.com/CustomAutonumber.htm

The DMax at the bottom would work for you, and you don't even need a criteria.