I need code to auto increment a text field. The field is alpha numeric. The structure of my field is as follows:
and so on.
The first part is the office, the second part is the 2 digit year and the third is the number that I need to increment. I created a form with an add new record button. what I need that button to do is create a new record and find the highest numbered control number and add 1. Based on the above structure. Also, if possible it would be nice if the coding could add the 2digit year without my intervention. This is a multi user database, but the access is minimal. 3-4 users.