am developing a project point of sales in VB6.0. I need a code to deduct the sold item from the data base . each time they make sale it will automatically deduct from the quantity in the database and also show stock level is low when the item quantity in the database is less than 10. i have 18 items in the database. my code could only work for one item it doesn't work for the rest .
Thanks.

Code:
Private Sub cmdsave_Click()
...