Get the value of a control on a form

[ready4data]

I have a form that has many calculated fields(hidden and shown) based on the data in the source table. The calculated values roll up to a textbox(txtAward) that shows an award(Gold,Silver,Bronze) based on the total calculated points.
There is no inputting in the form. Its just used to display what was input and what the final award is.
txtAward isn't part of the source table but can be added.
How can I get the txtAward value into the table so I can do some reporting?

Thanks,
Scott

 

[missinglinq]

You don't store calculated Values in Access Tables, you simply perform the calculations as needed, in your case, in your Report.

Linq ;0)>

 

[ready4data]

Correct.
I was thinking about storing the txtAward field as a variable and populating a table through vba as the records of the form are scrolled through.
Idealy if there is a way to open the form(hidden) and scroll through the records to populate a table with the needed controls from the form.

Scott