Main form and two Subs claculation

[Gaetanm via AccessMonster.com]

I have a form and 2 subforms

Main form [Job Sheet 1]
Sub 1 [Time Table Form]
Sub 2 [Work_hours_sub]

On my main form I have a text box called text125
I want it to give me total from Sub1 + Sub2


{SUB1} =[Time Table form].Form!Text22

{SUB2} =Work_hours_sub.Form!Sub_time_total

Each of the above will bring up its data into text125
INDEPENDENTLY of each other.


I would like to combine both of these into text 125 But I just
Don’t seem to be able to get it


=([Time Table form].Form!Text22 + Work_hours_sub.Form!Sub_time_total

Any Ideas?

Gaetanm

 

[KARL DEWEY]

Try this --
=([Forms]![Job Sheet 1]![Time Table form]![Text22]) + ([Forms]![Job Sheet
1]![Work_hours_sub]![Sub_time_total])

 

[Gaetanm via AccessMonster.com]

Thanks Karl
Your responce went a long way in better understanding forms and subs

Thanks again

Gaetanm

Try this --
=([Forms]![Job Sheet 1]![Time Table form]![Text22]) + ([Forms]![Job Sheet
1]![Work_hours_sub]![Sub_time_total])

I have a form and 2 subforms

[quoted text clipped - 20 lines]

Gaetanm