Hi People/Gurus
Can anyone guide me or provide an example using a form in access on how to generate a prefixed sequential auto-number based on a selection from a combobox:
Ie:
If Selected = "Cabinet Shop" then CAB_00001
If Selected = "Paintshop" then PNT_00001
If Selected ="MetalShop" then MTL_00001
Etc!
Etc!
Many Thanks in advance for any suggestions