<div>
Is the AutoNumber the 'ID' you are referring to ?<br />
And if so, as you saying it goes from &nbsp;5069 to &nbsp;50 ?<br />
If So. what is before 5069 ? Are they sequential ?<br />
<br />
mx
</div>


Is the AutoNumber the 'ID' you are referring to ?
And if so, as you saying it goes from  5069 to  50 ?
If So. what is before 5069 ? Are they sequential ?

mx

<div>
The auto number is the ID I'm referring to.<br />
If I look at the table in ID sequence, the first record ID is 50, second record ID 5069, and the rest of the records follow on sequentially from 5069.
</div>


The auto number is the ID I'm referring to.
If I look at the table in ID sequence, the first record ID is 50, second record ID 5069, and the rest of the records follow on sequentially from 5069.

<div>
Did you delete a bunch of records at some point ?
</div>


Did you delete a bunch of records at some point ?

<div>
Perfect, thank you. &nbsp;Why didn't I think of that???
</div>


Perfect, thank you.  Why didn't I think of that???

<div>
Sorry ... I had to leave work. hnasr beat me to the solution.
</div>


Sorry ... I had to leave work. hnasr beat me to the solution.

<div>
<div class="content wysiwyg-content">
I have a table with an auto number as the primary key. &nbsp;The first ID in the table is 5069.<br />
<br />
I have a vba function to add a new record to the table, using addnew and update. &nbsp;The function does not include a value for the ID field. &nbsp;<br />
<br />
When I run the function, the ID of the appended record is 50. &nbsp;<br />
<br />
How do I make the ID the next sequential number in the table?<br />
<br />
Thanks in advance.
</div>
</div>


I have a table with an auto number as the primary key.  The first ID in the table is 5069.

I have a vba function to add a new record to the table, using addnew and update.  The function does not include a value for the ID field.  

When I run the function, the ID of the appended record is 50.  

How do I make the ID the next sequential number in the table?

Thanks in advance.

Problem with auto number field inserting a record

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.