How to store value from unbound Text box to table?

  • Thread starter Thread starter Newbee
  • Start date Start date
N

Newbee

Hi,

I have form with 3 text boxes.
txtBox1 and txtBox 2 are bound to table One.
txtBox3 is unbound and calculates values from txtBox1 and txtBox2 like:
txtBox3 = [txtBox1] + [txtBox2]

Is it possible to store value from txtBox3 into table One?

Thanks from your help.
 
Newbee,

Yes, it would theoretically be possible, but generally there would be no
reason to do so, and in fact it is almost certainly a bad idea.
Whenever you need the value of txtBox1+txtBox2 for your purposes on
form(s) or report(s), you can simply do what you have done here, i.e.
calculate it in an unbound textbox, or else calculate it within the
query that the form or report is based on.
 
Back
Top