Working with a form

[Guest]

I have created an inventory database. I am stumped on how to get an on hand
balance on my form. I understand I calculate Units Received - Units Sold but
cannot figure out where to do it and how to get it to work. I would like my
form to be designed almost like the inventory database template. With the
inventory transactions table as a subform and product info as the main form.
Please tell me how to calculate this and what I am doing wrong.
Thanks....

 

[UpRider]

RG, check out aggregate function DSUM
It will allow you to sum a field in ALL the records in a table or query that
meet the criteria (ProductID)
You may need to use 2 DSUMs, one for sales and one for receipts.
If you put the calculations in a function then you can call the function on
the form's ON CURRENT event to update the textbox in which you wish to
display current inventory.

UpRider

 

[UpRider]

RG, I downloaded the Inventory Management template from MS to take a look.
In fact, the Inventory Details form has a textbox at the top labeled "In
Stock" which shows current inventory.
The textbox properties are set to Enabled = no and Locked = no so the text
box is grayed out against a grey background and is really hard to see. Set
the Enabled = yes and Locked = yes and then you can see it clearly!

UpRider