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.