How to store value from unbound Text box to table?

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.
 
S

Steve Schapel

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top