V
vandy
HELLO All,
Would appreciate if I could get help on a particular problem i am working on.
I am creating a simple inventory system that maintins records for all items
in and items out and also track items to order.
I have an item master, purchase master, inventory master table.
I have created a form were we enter the po number , date and has a subform
which is linked by purchase id as the child field in the inventory subform.
Based on the purchase id the corresponding record gets displayed on the
subform.
I have calculated Qty on hand using
=Sum(nz([QTY RECEIVED])-nz([QTY SHIPPED]))
This value gets calculated correctly while inputing qty recd and qty shipped
values but does not update the table.
Can you help me what i should do to update the value. I am not too good in
VBA coding too.
thanks a ton in advance
Would appreciate if I could get help on a particular problem i am working on.
I am creating a simple inventory system that maintins records for all items
in and items out and also track items to order.
I have an item master, purchase master, inventory master table.
I have created a form were we enter the po number , date and has a subform
which is linked by purchase id as the child field in the inventory subform.
Based on the purchase id the corresponding record gets displayed on the
subform.
I have calculated Qty on hand using
=Sum(nz([QTY RECEIVED])-nz([QTY SHIPPED]))
This value gets calculated correctly while inputing qty recd and qty shipped
values but does not update the table.
Can you help me what i should do to update the value. I am not too good in
VBA coding too.
thanks a ton in advance