Form and sub form Calculations Query (1 Viewer)

fsagwe · Sep 18, 2017

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 · Sep 18, 2017

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 · Sep 25, 2017

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 · Sep 25, 2017

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 · Sep 25, 2017

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 · Sep 26, 2017

Hello,

I tried but failed.

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

What went wrong?

Minty · Sep 26, 2017

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

Form and sub form Calculations Query (1 Viewer)

fsagwe

Registered User.

Ranman256

Well-known member

MdHaziq

New member

Attachments

Minty

AWF VIP

MdHaziq

New member

MdHaziq

New member

Attachments

Minty

AWF VIP

Similar threads

Users who are viewing this thread