I once had a code that created an alphanumeric value based on a combobox
selection in addition the code would check the record for the first two
letters then then add the next higher number to the corresponding cell. It
looked something like this XX001,XX002 and would keep adding based again on
the combobox selection, however I have sence lost the code and therefore
asking all you GURU's to help me recreated it. For the life of me I cannot
remember.

Thanks