newbie: calculation related mainform and subform only on current month

I have a stock control database. I created a query to find out total remained quantity of each product on only current month by using the delivered quantity on current month to subtract the quantity took out from the stock on current month. It works fine as I want.

But now I want one more thing:
I've just created a field "remained" in "products" table and a mainform named "products" with two subform: "stockout subform" and "subdelivery". In the main form have a "remained" control and this control have a control source "remained" in "products" table.
What I want is at "products" form, when I input the delivered quantity and the quantity that took out from stock, the "remained" control on the main form will display the remained quantity on current month. Of course, this control will write down the remained quantity to "remained" filed of "products" table.
thanks in advanced.

It would be advantageous if you post your sample db in Access 2000 format.

I converted it to 2000 version. could you check it for me?
many thanks.

I apologize for loosing this thread and only now I found it. Attached is the addition of the [remained] calculations. I also made some minor changes to your fields where I changed the Long Integer of the stock to Double. Also, blocked out some of your procedures because they caused an error partly because I don't have the same libraries as you do.

thank you for the help.
But I don't see any attached file of you to download. Could you post the corrected file for me?
thanks

Sorry, somehow it got lost. Here it is.

Hello,
really Sorry to bother you, but this time I don't see anything also. Something is wrong?
could you recheck if it really attached or not after you posted it.
thank you

The forum won't allow a file larger than 100kb That's why it didn't work.

My email is:
ineuw@aei.ca

Send me a message and I will forward it directly to you.

ok
many thanks