I'm very new to Access and I am trying to create a sequential numbering system. The first three digits are 0 followed by the last two digits of the current year. Following that is a dash and then a 5 digit sequential number, so the overall format looks like 019-00001. I have the following so far but I can not figure out how to get the sequential numbering code.
Private Sub Access_button_Click()
Me.Access_Log_Number = Format("0") + Format(Date, "yy-")
The table is named Access_Number_Assignment.
Please help!