Main form and two Subs claculation

  • Thread starter Gaetanm via AccessMonster.com
  • Start date
G

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
 
K

KARL DEWEY

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

Gaetanm via AccessMonster.com

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

Thanks again

Gaetanm

KARL said:
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]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top