If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Unanswered: Keeping track of Quantity

My problem is keeping track of Quantity.
I want to be able to have a text field in the Form that will add then update the quantity.

For example if I had Part Name = Keyboards Quantity = 5. Then on the next record I've added 2 more with using a Text Field, then I want the next record in the tblQuantity to say 7 keyboards. I do not want to UPDATE the record.

My problem is keeping track of Quantity.
I want to be able to have a text field in the Form that will add then update the quantity.

For example if I had Part Name = Keyboards Quantity = 5. Then on the next record I've added 2 more with using a Text Field, then I want the next record in the tblQuantity to say 7 keyboards. I do not want to UPDATE the record.