Auto number will start from 10 not in 1

[Neil]

I have created a Data entry form wherein they enter outgoing faxes. They are
already in number 51775, which they call the reference number and they are
writing this manually in a book. They want that to be automated but they want
that the next number to appear is 51776.

I have been trying to make this work but i still end up with 1. I cannot
find within the help command any mention on how to solve this problem.

Can you please assist me in this. Thank you.

 

[NG]

Hi Neil,

it is possible to start an autonumber field with another number then 1 (see
Access help), but it won't help you much. Whenever you enter a new record,
find out you make a mistake and restart, the autonumber that was created is
lost, and you have a "hole" in your numbering. A better solution in this
case is to create a normal number field - type long and then fill it with a
counter such as
myField = Dmax("myField","MyTable") + 1
or work with a separate numbering table.