Format Control on Auto Numbers

[QA_Compliance_Adviso]

I would like to expand on this questions. I would like to generate a number based on a reference I use, a format like "14/000" where I use "14" with the last 2 digits of the year. However i want the auto number to generate the the last 2 digit automatically when the year changes i.e. when 2015 comes the field generates "15/000" without any prompt from the user.

Is this possible?

 

[GinaWhipp]

Yes that is possible using DMax() combined with Format but a wee bit more information...

1. Are you saying you will only have 999 records for the Year? If more then...
2. Is it okay to go to 1000, so you will see *14/1000*?
3. Assuming this is going to be when a new record is added, is there a button? And, is there any other code on the button besides the going to a new record?