Subform textbox calculation send to Table (1 Viewer)

[sargon]

I have tables tbInvoices and subtbInvoices and forms frmInvoices and subfrmInvoices.

I need that a calculation from subform subfrmInvoices to be sent to the corespondent field in table subtbInvoices.

In the subfrmInvoices (and in subtbInvoices) I have 5 fields :
Combox
TexboxID
textbox1 - I input manually
textbox2 - is generated automatically (After_Update Combobox this textbox is the result of a query)
textbox3 - is the product of the two textbox above (textbox3 = [textbox1]*[textbox2])

I really need to store textbox3 because texbox2 is calculated using a formula based on the sum of the texbox1 and texbox3!

Is there a way to transfer the calculation in table directly, without manually type it?

I belive that VBA "Insert Into" is not a solution...

 

[pbaldy]

Noting the caution against storing a calculated value:

http://allenbrowne.com/casu-14.html

2010 has a calculated field data type.

 

[sargon]

Yes, it works! Thank you.

For my curiosity... is there a way to make calculation in the subform and send it to table (not to make the calculation in the table), simillary to that when I type it?

For a simple form the solution is Insert Into...