Increase Product Quantity in Subform after Scan Barcode

[m_sami9]

I've built a POS for my shop. I have built a barcode field in form, when I entered a barcode medicine adds in subform, scanning again the barcode a new row increase but I want only Purchase Quantity increase in subform.

 

[CJ_London]

what code are you using to populate the record? whatever it is it would need to be modified - presumably to scan existing entries and if already exists, add 1, otherwise add a new record. What that modification is depends on what code you use at the moment

 

[adhoustonj]

Do you just click in the product/productID field and then scan, or do you click a button and then scan?

I use:

bcode = InputBox("Please scan product")

You could then have your if bcode = x then this else that.

 

[arnelgp]

what if the price is different, how will you add it?

 

[arnelgp]

no, not possible. what if you purchase productID 1 @ 30.00 with qty=500.
then later you purchase same product @ 28.95 with qty 10, you mean
you will change All the price of productID 1 from 30 to 28.95?
you will incurr loss.