Storing numbers that come from calculations

[ckpoll2]

Hello,

I've built a form that will pull different numbers from different areas and add them up. There are text boxes on this form sum up a series of numbers. What I need to do is store these summed numbers in a table. I don't understand how to do it because in the control source field in the text box properties, I have the formula, so it won't let me give a field in a table to store it to.

Is this possible?

Thanks,

Charlie

[PEB]

Yeah,

It is possible, but you have to assign the moment of filling in...

For exemple you can do it when other control is updated... In after Update Event you say

Me![Textbox]=Me![Calculation]

And so...

:)

[ckpoll2]

I'm not sure I understand that formula. What would I type into the control source field of a text box if I wanted it to equal the calculated number in Textbox 269, for example?

[PEB]

So imagine that you want to set the value when you enter in your textbox!

On Got Focus Event in the wanted textbox you enter:

Me![Wanted textbox]=Me![Textbox 269]

And when you enter in your field the result is set!

:)