Calendat year autonumber generation in table

[nishant.dhruve]

Hi is it possible to generate autonumber in calendar year form in Table
for example i want number to be generated something like this based on year

EU17/0000
EU17/0001
EU17/0002

and when year changes it should change automatic to

EU18/0000
EU18/0001
EU18/0002

if anyone can help me out on it i would greatly appreciate your efforts on helping me.

[ranman256]

building your own 'autonum' like this will require vb and how to use it.
In a form where you add a record you would need a button to create it (by running the code)
in the example the button btnMakeID will put the new id into a text box, txtID:

sub btnMakeID_click()
vID =nz( DMax("[ID]","table")) + 1
txtID = "EU" & right(date,2) & "/" & format(vID,"0000")

end sub

[nishant.dhruve]

Hi i have attached a table snapshot. i would like to add a number to this table automated. Can u help on that with the format above