Save a form value to a table

[bmwccn]

I`ve got one text field in my form which calculates the precentage of two numbers. The mathematical formula to this operation is placed in the textfields properties/contollsource. I want the value of this field to be saved in the form`s table. How do i do that??

 

[Mile-O]

I want the value of this field to be saved in the form`s table.

Why? If you can calculate it on the form then, the next time you open the record on the form, the calcualtion will still show the value you want.

If you store calculations in a table then you are violating the Third Normal Form (3NF) of database design, and can't, therefore, call your database normalised.

 

[bmwccn]

Making a report

The reason why I want to do this is so I can make a report out of this table later. If i don`t get this value into the table the report will not be complete .

 

[Mile-O]

The reason why I want to do this is so I can make a report out of this table later. If i don`t get this value into the table the report will not be complete .

Then I counter with why are you binding a table to a form in the first place? A query is best as the RecordSource for a form and, to save space, the same query can be used in the report. The calculation can also be done in the query or on the report.

 

[Mile-O]

Maybe this attachment will help to demonstrate.