C
Corliss
hello all,
I am making a new point-of-sales system running on access 2003. I have a
form called pos that has a subform called Q02Line. I am trying to alter my
Table.Inventory.Qty(quanity) when an item from inventory is sold.
so I created a while loop that runs through as many times as there are
objects being sold. I need this process to access the subform before close
and minus the amount sold from the inventory table.
Inventory has a PK UPC and Qty, sales rep, distributer,price
and the subform has UPC (which is the inventorys upc) , L-Qty which is the
number of objects being sold and receipt number.
I have many other tables but this is the one I cant figure out?
I am making a new point-of-sales system running on access 2003. I have a
form called pos that has a subform called Q02Line. I am trying to alter my
Table.Inventory.Qty(quanity) when an item from inventory is sold.
so I created a while loop that runs through as many times as there are
objects being sold. I need this process to access the subform before close
and minus the amount sold from the inventory table.
Inventory has a PK UPC and Qty, sales rep, distributer,price
and the subform has UPC (which is the inventorys upc) , L-Qty which is the
number of objects being sold and receipt number.
I have many other tables but this is the one I cant figure out?