Make textbox from subform display and store in main form

[ryanwales]

I have a quote form that facilitates the selection of multiple products. There is a main form (QuoteNew) and a subform (QuoteDetails).

When product(s) are chosen and the total price (txtTotalPrice) is made, there is a textbox in the footer of the subform that caluclates the cumulative total of txtTotalPrice via a Sum function.



I need this Sum (txtSum) to appear in txtQuoteSubtotal and for it to store as the subtotal in the quote table. I have been able to make txtSum appear in the txtQuoteSubtotal textbox but it wont save.

Do i need to do an after update in txtSum? If so, what is the code?

Thanks in advance

[June7]

Really should not be saving aggregate calc results.

It will require code to save calculated values. If the field is included in the form's RecordSource, in VBA simply:
Me!fieldname = Me.txtSum

The trick is deciding what event to put this code in. Suggest in Click event of a button that closes the form then also disable the X close button.

[ryanwales]

Really should not be saving aggregate calc results.

It will require code to save calculated values. If the field is included in the form's RecordSource, in VBA simply:
Me!fieldname = Me.txtSum

The trick is deciding what event to put this code in. Suggest in Click event of a button that closes the form then also disable the X close button.

Hi June, thanks for the swift response! would that code work as there is a main form and subform involved?
So the trick would be to have a button such as 'update price' where once clicked, txtSum would be passed from the subform to txtQuoteSubtotal in the main form?

[pbaldy]

To make sure nobody goes over the same ground twice:

https://www.accessforums.net/forms/m...orm-18366.html

[June7]

Not quite. The textbox ControlSource would be an expression that is simply like (this syntax is tricky):
=Forms!mainformname!subformcontainercontrol!textbo xname

Name the subform container control different from the form it holds.

The textbox will automatically recalc. The code is needed to save value to table. However, I repeat, saving aggregate data is usually not necessary and often bad design.

[ryanwales]

I can get txtSum to appear in txtQuoteSubtotal just by using [Child10].Form![txtSum] but I obviously want it to store as the subtotal since a record needs to be saved. that way, the total quote price can then be calculated.

The idea of a 'container' seems alien to me, at least i'm not familiar with the term if i somehow know what it is, can you elaborate?

[June7]

A subform is a form that is held by a subform container control. It is another control available on the control toolset. The container control has its own properties, such as the Master/Child links that synchronize the RecordSources of the forms. Click the edge of the subform, this selects the container. Click inside the edge and this selects the form.

[ryanwales]

And it's solved!! Thanks both, really appreciate it.

I have one last problem and i'm done with it! heres the link to it:

https://www.accessforums.net/forms/m...html#post87394

Once again, thank you!