I am using Microsoft Access 2.0 and am trying to edit a form design that has a number sequence in place according to the date and the number of cases in that given year. For example, the starting number sequence for this year would be 2002-001 and then 2002-002, 2002-003 and so on....
Whenever you enter in data on a new form the the last three digits of the number sequence is automatically added by one incrementially. Unfortunately, the number sequence is still set in 2001 and adding on numbers for each new form I open. I need to start from 2002-001 to denote a new year's cases.

I would really appreciate it if someone could help me or point me in the right direction.

-Scott Angus

You'll have to find the piece of code that is generating the numbers. That code may be using a literal value for the year part of the number rather than extracting the year part of the current date.

Thank You,

So how do I find that literal value and change it. When I gain access to the design mode, I do not have the ability to change anything.

Thank you,

Scott Angus

Is your front end a .MDE file? If it's pre-compiled, you'll have to find a regular .MDB file that you can edit and recompile.