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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top