I have  a form Product that contains the Product Name and and the Available Quantity.

This is added through lookup into a subform in another form.

I need to update the value of Available items with respect to the Required quantity in the subform.

Any idea how to do that, because storing the value in as it is retrieved is not working.