Unanswered: File attched for barcode question in form
I have table that has these fields
Each product has barcode number and there are two kinds of barcode one with 8 (12345678) digits and one with 9 (123456789) digits what I like to do is scan each product by barcode reader which will read the barcode as text and then I like to code as this
8 digit barcde = 12345678 the first three digits are the [ProdNumber] and digit 4 and 5 are [SerialNumber] and the last three as [EndingNumber].
9 digit barcode = 123456789 the first four digits are the [ProdNumber] and digit 5 and 6 are [SerialNumber] and the last three as [EndingNumber].
Also I designed form for data entry which has all the fields in the table and unbound field for barcode reader. I don’t want to store the barcode reader (I’m not sure if I should) but I want to scan each item and then separate the barcode as above. I attached file here.