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!