I developed a barcode to scan with a barcode scanner for scanning article numbers.
Some articles allready have a barcode. So I thought: If we scan sometimes the new barcode for the article number and some times the barcode allready on the product and read them from the scanner in a new field. I maybe can match the value of scan to the combo field on the same form. my article numbers are always like "10000-001" and barcodes a 8 value or 13 value.
So when I scan and they match one of the fields, I can read them in one new field but when it is aan article number it has to match this number to the article number field (dropdown productid article number) and if it is an ean barcode number it has to match the (dropdown productid ean)
Can you help me out please?
Private Sub Scan_AfterUpdate()
If Me![Scan] Like "*-*" Then Me![ProductID].Column(2) = Me.Scan Else
Me![ProductID].Column(3) = Me.Scan