I need to write a little code that generates a number that equals the last number plus one each time a new record is appended, and writes it to a field in that record when the save button is pressed. It should cancel the number if an exit w/out save is executed.

An extra would be that I want to make it start back at zero at the beginning of the year.

If someone could give me some code, a hint, or just point me in the right direction, I would really be endebted.

Thanks ahead of time,
Jimmy Ditta