trying to pass the sum of two other text boxes to a field

[pikou]

Hi everyone this is my first post here so please don't throw any chairs at me.
Here's the thing I have a form which has two text boxes whose sum I want to pass on to a third text box but update the value on the table field it is connected to.
I hope I made my self clear.
Thanx for your help in advance

 

[KenHigg]

Bad juju...

 

[pikou]

Sorry but this is not helping me very much.
Could be more specific???????

 

[Mile-O]

If you can calculate the value on a form then you have absolutely no need to store the value in a table.

Storing a calculate value would go against the Third Normal Form (3NF) of database normalisation as it would leave your data prone to errors.*

* That's a search term for you.

 

[pikou]

Thanks very much for the reply but i need to update the field in the database so that I may export the table to another application at a given time and have all the data there.
That is my problem

 

[Mile-O]

i need to update the field in the database so that I may export the table to another application at a given time

Don't ever work directly with your tables; just let them collect the data. Aways use queries - bind them to forms, reports, etc. All you have to do is base a query off your table and perform the calculation in the query. Export the query at any given time.

 

[pikou]

Thanks a lot !!!!!!
Your insight really helped me understand and I did it.
Many thanks