Ok im confused

[JonatABS]

Why is this so difficult??

I have a field on a form with a calculation on it. It works!! However I want that too fill out a field on a DIFFERENT table.

HOW THE HECK DO I DO THAT!!!!!

 

[Mile-O]

...because the idea of relational databases is that you don't store calculated values in a table. If you can calculate it on a form then the next time the same record is opened on the form the same result will be calculated again, anytime.

Storing values, bad. Following third normal form, good.

 

[JonatABS]

Ok with that hearty note, How can I get that value to show up on a different text box on a different subform.

(I tried finding this but had no clue what to search for)

 

[Mile-O]

The Word document on this thread details how to reference controls from different forms, subforms, etc..