Calculated field in a Form.

[RKatt]

OK I will try to make this understandable...
I have created a form that is based on a table.
The fields in the form are currently pull downs or manual enrty fields (all based on the columns of the table... "Bound" I think you call it).
I also have fields that I manually brought into my form as text boxes that I am using to populate a series of numbers. I have named them P1, P2, P3 etc. They are unbound fields.
I have a field that I am totalling the unbound fields. It is a column in my table. At one point the control source name was the table coulmn name.
I have changed the control source to read =[p1]+[p2]+[p3]+ etc.
The total does show up in the field on my form
HOWEVER.... When I save the data the total number does not get brought into the table. All of the other fields do.

Confused..... REALLY Confused.

 

[pbaldy]

You've pointed out yourself that you no longer have the textbox bound to the table column (the control source), so how would it save? This should help:

http://allenbrowne.com/casu-14.html

 

[RKatt]

Re: New Flunkie....

Hey pbaldy.
Just reading thru the liknk you sent me....
From what I can understand it is telling me to create a query based on a table.
The unbound fields that I have the raw data in is in a form and not in a table. Therefore I cannot pull the fields down to make the query...? Am I out to lunch?

 

[RKatt]

Re: New Flunkie....

.. or do I create the query in the table I want the data to be stored and write the formula given in the xample there.. If so how do I tell the formula that it is in an existing form?

 

[RKatt]

Re: New Flunkie....

something like this...
Sum: [form]![main proppant form]![p1]+[form]![main proppant form]![p2]+etc

BTW Thanks for the quick responce.....

 

[pbaldy]

Well, the basic theory of normalization is that you don't save a calculated value; you calculate it "on the fly" as needed, in a query or on a form/report. If you decide you need to save it, then you need the code type solution to place the calculated value into a textbox bound to the appropriate field.