Totals from subform

[Rose B]

I have created a subform which totals values, when present, in a field. I
then use that total in a field in the main form. In the control source of the
main form field, I have entered "=IIf(IsError([qryClientGrpTrips
subform].[Form]![GrpPassNum]),0,[qryClientGrpTrips
subform].[Form]![GrpPassNum])".

This worked fine, so I added the same subform to another main form, where I
want to use the total field again. This time, using exactly the same control
source I get "#Name?" displayed in the form field. The subform is displaying
OK. Any ideas greatly appreciated - this is driving me potty! (Especially as
I have one more form that I want to add this same subform into). I have
looked around the discussion group but cannot find anything that seems to
help - I am a novice so would appreciate detailed advice if at all possible!

Thanks,

 

[Stuart McCall]

I have created a subform which totals values, when present, in a field. I
then use that total in a field in the main form. In the control source of
the
main form field, I have entered "=IIf(IsError([qryClientGrpTrips
subform].[Form]![GrpPassNum]),0,[qryClientGrpTrips
subform].[Form]![GrpPassNum])".

This worked fine, so I added the same subform to another main form, where
I
want to use the total field again. This time, using exactly the same
control
source I get "#Name?" displayed in the form field. The subform is
displaying
OK. Any ideas greatly appreciated - this is driving me potty! (Especially
as
I have one more form that I want to add this same subform into). I have
looked around the discussion group but cannot find anything that seems to
help - I am a novice so would appreciate detailed advice if at all
possible!

Thanks,

Check to make sure you have the name of the subform control correct on your
2nd form ([qryClientGrpTrips subform]).

 

[Rose B]

Darn!!! Thought I had, but clearly not carefully enough.... a copy/paste to
be sure did the trick. Thanks

I have created a subform which totals values, when present, in a field. I
then use that total in a field in the main form. In the control source of
the
main form field, I have entered "=IIf(IsError([qryClientGrpTrips
subform].[Form]![GrpPassNum]),0,[qryClientGrpTrips
subform].[Form]![GrpPassNum])".

This worked fine, so I added the same subform to another main form, where
I
want to use the total field again. This time, using exactly the same
control
source I get "#Name?" displayed in the form field. The subform is
displaying
OK. Any ideas greatly appreciated - this is driving me potty! (Especially
as
I have one more form that I want to add this same subform into). I have
looked around the discussion group but cannot find anything that seems to
help - I am a novice so would appreciate detailed advice if at all
possible!

Thanks,

Check to make sure you have the name of the subform control correct on your
2nd form ([qryClientGrpTrips subform]).