S
segurarl
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!
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!