Adding Calculated fields to Table with VBA (1 Viewer)

[Heatshiver]

I have a form that contains 3 subforms. Each subform consists of calculated (unbound) fields that are from calculated query recordsources.

My goal is to add the values produced by these unbound subform fields to one table.

I am unsure how to go about this. I at first thought that Allen Browne's copying of subform values to a table would help (http://allenbrowne.com/ser-57.html), but I have not been able to get it to work for this.

I have used Browne's method for other forms, but they have always involved the tables used in the queries. For this particular form, the table I want to add the values to is not used for the queries producing the calculated (unbound) field values.

Any guidance or direction would be much appreciated!

 

[joemach]

What reason do you have to save the results of a calculated control (or query) into a table. This would normally be considered bad database design practice.

 

[Heatshiver]

I consider this bad design practice as well, but the client may not use MS Access in the future, so they want the values stored for now.