calculated field from sub form datasheet

[Guest]

My form has this format:
1) Main form...Single form
-> sub-form1.....datasheet
-> sub-form2......datasheet

sub-form1 has a numeric field: Order
sub-form2 has numeric field: Received

I need a field in sub-form1 to calculate the total of [sub-form2].[Received]
and compare it to 'Order' so I know when the order has been completed.

I have tried a field 'subTotal' in the footer of sub-form2:
'=sum([Received]), but when I put a reference to 'subTotal' in sub-form1 I
get '#Error'.

Thank you for your help!

 

[Guest]

You can try this format:

=Forms![main form]![sub-form2].Form!sub-form2

This usually works for me.

 

[Guest]

Thank you!
I have tried it before but it doens't work when I try to get the total the
value on the field

You can try this format:

=Forms![main form]![sub-form2].Form!sub-form2

This usually works for me.

--
Amy E. Baggott

"I''m going crazy and I''m taking all of you with me!" -- Linda Grayson

My form has this format:
1) Main form...Single form
-> sub-form1.....datasheet
-> sub-form2......datasheet

sub-form1 has a numeric field: Order
sub-form2 has numeric field: Received

I need a field in sub-form1 to calculate the total of [sub-form2].[Received]
and compare it to 'Order' so I know when the order has been completed.

I have tried a field 'subTotal' in the footer of sub-form2:
'=sum([Received]), but when I put a reference to 'subTotal' in sub-form1 I
get '#Error'.

Thank you for your help!