I have two fields..on two different forms..the output needs to be the same.
FormA.field b = FormB.field a
FormA.field b is a calculation on form A....the end result.
On FormB that needs to be my beginning number. I have tried everything that I could think of..also the fields are a part of a subform on both forms
I have tried
Forms![fsub_Final_Table Query1]![txtTotalBC1]..this is
fsub_Final_Table Query1 (FormA) is the subform and txtTotalBC1 is the resulting field on FormA...I am placing all this into the control source in FormB.FieldA
FormA.field b = FormB.field a
FormA.field b is a calculation on form A....the end result.
On FormB that needs to be my beginning number. I have tried everything that I could think of..also the fields are a part of a subform on both forms
I have tried
Forms![fsub_Final_Table Query1]![txtTotalBC1]..this is
fsub_Final_Table Query1 (FormA) is the subform and txtTotalBC1 is the resulting field on FormA...I am placing all this into the control source in FormB.FieldA