Have a form. When a new record is created goes to a table to get its numbering and increments a counter. Then prefixes the year the number and populates a text field. So for example 19-240, 19-241 ...
This works in MS Access 2016 and was working in 2019. In version 1808 build 10352.20042 Click...