Pushing data to a bound text box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How would you push data to a bound text box? I got a form with a subform in
the footer of the subform I have a unbound text box that keeps a running
total of one of the fields in the subform txtBoxSum = sum(Income)). And then
I display the running total to the main form
[TableSubForm].[Form]![txtBoxSum]. This all works OK. But how can I get this
value to a bound text box?
 
How would you push data to a bound text box? I got a form with a subform in
the footer of the subform I have a unbound text box that keeps a running
total of one of the fields in the subform txtBoxSum = sum(Income)). And then
I display the running total to the main form
[TableSubForm].[Form]![txtBoxSum]. This all works OK. But how can I get this
value to a bound text box?
Click to expand...

You're using an Access database, not a spreadsheet!
Don't save it.
Storing calculated data is usually wrong in Access. It wastes space
and leads to erroneous data if one of the units in the calculation has
been changed.
Anytime you need the result of the calculation, re-calculate it, on a
form, in a report, or in a query.
 
I know I can do a query to do the same thing but for this application I’m
trying to figure out which way I’m going to go with this form. And it would
just be a lot easier right now if I could just push a valve to a bound text
box. And I have some other reasons I would like to do this too.
--
thank You


fredg said:
How would you push data to a bound text box? I got a form with a subform in
the footer of the subform I have a unbound text box that keeps a running
total of one of the fields in the subform txtBoxSum = sum(Income)). And then
I display the running total to the main form
[TableSubForm].[Form]![txtBoxSum]. This all works OK. But how can I get this
value to a bound text box?
Click to expand...

You're using an Access database, not a spreadsheet!
Don't save it.
Storing calculated data is usually wrong in Access. It wastes space
and leads to erroneous data if one of the units in the calculation has
been changed.
Anytime you need the result of the calculation, re-calculate it, on a
form, in a report, or in a query.
Click to expand...
 
Back
Top