I have a form with a combo box that have 5 option to select. I need that if the person select the first option exmaple: LAN(L), then the txtIDNo. = L001, if the person select the option 2(example:PLC(P)) then the txtIDNo= P001 etc...
The problem is that each IDNo. is incremental:
each record heve a IDNo. that identy the recor depending of the option that select in the combobox. Please if any people can help me, thanks!!!!