One of the great advances of Access/Sharepoint is the simplicity of the architecture to reduce macro creation and simplify data analysis:
In the "List View" by simply entering the relevant 'Barcode' in the existing search field, the inbuilt filtering system will display corresponding stock item...