Update Invenotry Qty

S

SAC

I'm working with a Purchase Order form and updating the Inventory quantity
on order as items are entered on the form.

When an item is entered I use a SQL statement to increase the quantity on
order of the inventory item.

When the qty is changed can I use the before_update event of the form to
remove the old qty and the after_update to add the new qty?

Thanks.
 
S

SAC

I need to be able to capture the value of a control when I press the delete
key with code. Me!qty shows the default value in both the before delete
confimationa and the after. The qty goes to the default value and I'm
missing how much was in the control before it goes to the default value of
1.

Thanks.
 
Top