i want to make auto generated item number look like this
item001
item002
and so on
when i saved the item001 the next time i try to input new item it will give me item002 and so on...

Thank You.
i am using ACCESS

Where you are saving the items in database or some where else?

Where you are saving the items in database or some where else?

i am using access sir.

since you are storing the data in the DB , need to read the max of existing number and increment the same by 1 to get the new number and concatenate the same with your string.