Saving Calculated subform Values on Main Form

[ElmoScheffer]

Hi,

I have a subform with a calculated field in the footer that I display on the main form. My main form with various other fields on it is linked to a table. I need to save the value that I get from the subform (that is displayed on the main form in a text box) in the table of the main form. How do I insert this value into the main form table.

Thanks

Elmo

 

[maxmangion]

Hi,

Since it is a calculated field it is not recommended that you store its value in a table. What is the reasoning that you wish to store this value ? ... if you need to use elsewhere i.e. other forms, reports etc, then consider creating your calculated field in a query and base your form on that query.

 

[ElmoScheffer]

Hi maxmangion,

Thanks for your reply,

My subform is basically a grid with lots of values. Rows and cloumns.
The calulated field on the footer of my SubForm sums all these values and this one value is then displayed on the main form as a total. I need to store this one value in a transaction table. The main form is bound to this transaction table.

The values in the subform grid is not saved in any table and live on the subform until the main form is updated. Thereafter it is refreshed and the process starts again.

I hope this makes more sense.

Regards

Elmo

 

[gemma-the-husky]

just refer to it in the parent form as

subdetails!subfield

subdetails is the name of the subform in the parent form
subfield is the name of the field in the subform