Main form and two Subs claculation

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Gaetanm - 07 May 2007 23:08 GMT

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

Reply to this Message

KARL DEWEY - 07 May 2007 23:27 GMT

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

Signature

KARL DEWEY
Build a little - Test a little

> I have a form and 2 subforms
>
[quoted text clipped - 20 lines]
>
> Gaetanm

Reply to this Message

Gaetanm - 09 May 2007 04:22 GMT

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
[quoted text clipped - 5 lines]
>>
>> Gaetanm

Reply to this Message