Code to Generate a sequence number

[shod90]

Dear Gents,
Um trying to create a code generator for my stock
I need vba code or somehow to create the following :
1 - create automatic Code with this format " 100001 "
2 - Increment by 1 every time i add a new record
Is it applicable ?

[orange]

See the links at the bottom of the page under Similar Threads