Windows XP 
Access 2003
Start Autonumber at a specific number
I have recenly taken over a database which has Invoicing as one of its components. The previous designer used a series of queries attached to a button to add a new Invoice number, however this is OK if you do only one Invoice at a time. I would like to use the AutoNumber field so I can run a batch of Invoices but I need to follow on from the existing numbers. I recall seeing a procedure that would start the AutoNumber at a specific number but can't seem to find it in the "Help" or my programmers reference book. Can someone please advise.
Reply With Quote
