Forms - Barcode question in form

I have table that has these fields
[ID],[SalesDate],[ProdNumber],[SerialNumber],[EndingNumber]
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.
Thanks

Don't see an attachment to your post. To parse the barcode strings utilize Left, Right and Mid functions. This should be fairly easy since you know the positions of the values you want to extract. For instance, just to give you a start:

How do I attch file in here

Just learned this. You may not have been a member long enough yet. At end of postings after Quick Reply box is dropdown box 'Posting Rules'. This will show your permissions. If you have Attachment permission then when you create a post or reply, scroll down the screen and find Manage Attachments button.