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

Similar Threads

Editing a text file 1
Can I put a Formula into an Excel User Form? 1
Creating a Search using a combo box and then creating a report. 4
How can I open an Excel Workbook from Outlook macro and activate that workbook? 1
Populating the data of two Textboxes into One textbox 11
value from cbo box and text box 3
cangrow text beside and under image 2
Pass the variable into the sub function 4

Top