Generate my own autonumber?

It can be done. Instead of an autonumber, just use a number field as your
primary key. In the Before Insert event of the input form, do a DMax of the
PK number field and add one to it.

Something like this will work as long as there aren't too many people
entering records into the database at once. There's a very slight possibility
that two people could try to insert the same number at once. As the field is
a PK, one of them will get an error.
--
Jerry Whittle
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"Alec M1BNK" wrote:

How is the question. i need to create an auto incrementing number for each
successive record, but one which will maintain the sequence infallibly with
no gaps.

Before anyone asks, here's the why. Our accounts manager is unhappy becase
the autoinvoicing system I have implemented inside an access database, uses
the autonumber record ID from the table of invoice data to generate an
invoice reference number. As we all know, any database using autonumber
aquires gaps, missing numbers from the sequence, more users = more mistakes =
more gaps. Apparently the auditors might think there is something fishy going
on if the invoice numbers are not in perfect sequence.

Alec