populating a field in the a table associated with a form and subform

[fab547]

Good morning
I have created a table with fields to be populated out of subforms attached to the main table form.
Each field in the main form is populated with the individual calculation os each subform subtotal. So far it works. But looking up the table all the fields are blank. The total of each individual subtotals is also shown on the main form. That works too. That total is linked to the same field name as in the table "itemcost" but that total too does not show on the table.
I am zero in VBA so I am only using the facilities of access 2016. What can I do to solve this issue? Thk u for your help.

[zmbd]

> Before we get in to how to accomplish your goal, we really have an obligation to point out a few things:

+ Unless it is for regulatory or transient/mutable/one-time information (i.e. a special one-time discounted price on an item), storing calculated results is not normally recommended for 95% of situations. Instead, calculations are usually performed within the query on an as-needed bases.

+ The control source of a form-control cannot be linked to both a calculation and a table. There are various methods of transferring the calculated value; however, as above, this is not normally done.

+ Using sub-forms to fill in the data on a parent table suggests that there is an issue with your overall database design. I suggest that you take a few moments to read thru:
home > topics > microsoft access / vba > insights > database normalization and table structures

+ Check you Bytes.com inbox, I'll forward you a copy of a boilerplate with some resources. It's starting to be a bit dated with Acc2010; however, the core concepts and references are still valid :)

-z-