Hi,
I have a simple inventory which has an order form (continuous form)
I want to be able to scan barcode from 2 or 3 fields in a table like, an Item can have UPC or JAM or EAN code. So when any of the code is scan, the same Item show pop up.
Below are the tables with their fields:
tbItem= ID, ItemName, ItemCode1, ItemCode2, ItemCode3
tbOrder= ID, QtyOrder, DateOrder, ItemID
Please I need the easy way out using combo box or textbox
I have a simple inventory which has an order form (continuous form)
I want to be able to scan barcode from 2 or 3 fields in a table like, an Item can have UPC or JAM or EAN code. So when any of the code is scan, the same Item show pop up.
Below are the tables with their fields:
tbItem= ID, ItemName, ItemCode1, ItemCode2, ItemCode3
tbOrder= ID, QtyOrder, DateOrder, ItemID
Please I need the easy way out using combo box or textbox