get the value from unbound text field from FORM and store the value in a boundfield

[danieltaylor]

Hi,


Ive created a data entry form w/ 7 fields.... [f1], [f2], [f3], [f4], [f5], [f6] are bound to a table. While [f7] is unbound and has Nz function.
Now, the value of [f7] is the summation of [f1] to [f5], i want that what ever value is generated by [f7] will be stored on [f6] in both forms and table...

[pbaldy]

I wouldn't save a calculated value, but in 2010 you have the new calculated field available. I'd also wonder what the 5 fields contain, as it doesn't sound normalized.