calculation problem

[datahunter]

I am working in several tabed forms with one table, I have worked out a sum
for several fields and all is good.... what i cant do is bring that value to
a new field
in another tabed form. Like this form A with obj1 + obj2 + obj3
shows
value in "total" how do i get value "total" in form A to a new field in form
B? Thanks all for your help!!

 

[Allan Murphy]

If form A & B are open you could
"push" the value to form B using form!form_B!new_value =me!value

or "pull" the value from form_a using me!new_value=form!form_A!value

value is the name of the field in Form A new_value is the name of the field
in Form B

Allan

 

[John W. Vinson]

I am working in several tabed forms with one table, I have worked out a sum
for several fields and all is good.... what i cant do is bring that value to
a new field
in another tabed form. Like this form A with obj1 + obj2 + obj3
shows
value in "total" how do i get value "total" in form A to a new field in form
B? Thanks all for your help!!

Do the calculation in a Query, not in your form; the query can be used as the
basis for either or both forms.

John W. Vinson [MVP]