Change a code

[Benniit]

Am using VB6 and i have a field called serial Number e.g. 0001.
I want this number to change the following day as 0002 and the next day 0003 in that order. I want it to change just like the system date. So if the number is 0001, then tomorrow it should change to 0002 and so forth

Thank you.

Ben

[debasisdas]

you can update the field based on system date.