Form and sub form Calculations Query

[fsagwe]

I have a form with sub forms . Each sub form has a textboxes getting me a total value of a field. In the main form I want to add a textboxes that will sum up values in the textboxes of the subforms. Help!

 

[Ranman256]

in the FOOTER of the subform, put a text box to total all recs
=Sum(field)

in the parent form, put a text box to look at this field in the subform footer.
=forms!subform!form!txtBox

(use the BUILDER to get the path name correct!)

 

[MdHaziq]

Hello,

I want to do something similar.

I would like to change the qty when a user wants to withdraw or stock in an item.

How can I go about doing it?

I have attached a rough design of the form and storing the new qty in the table.

 

[Minty]

You shouldn't store an on hand quantity, you should always calculate it.
And you are storing Stock In and Stock Out as separate items - again they should be in the same column - Positive values In - Negative values Out.

Please have a good read here http://allenbrowne.com/AppInventory.html for how you should approach this project.

Good luck.

 

[MdHaziq]

Thz for the link and the comment.

I have read it.
I will get coding when I get home.
Any problems I will post back here.

I hope you will be here

 

[MdHaziq]

Hello,

I tried but failed.

My qty textbox shows#Name?, something like that.

What went wrong?

 

[Minty]

Okay - you haven't grasped the concept yet. There is a sample here based on Allen Brownes example. maybe it will help you.
https://access-programmers.co.uk/forums/showthread.php?t=219125&highlight=Inventory