Hi, I'm trying to build a data entry form for an alumni database. I want to generate an unique ID for each alumni. The id is 8 digit alphanumeric. The last two digits is a sequential serial number which should restart from 01 for each new class and gender group within the class. Not sure if I'm making any sense, but would be delighted if could get some idea or simple VBA code. Thanks in advance.