Totals from subform

  • Thread starter Thread starter Rose B
  • Start date Start date
R

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,
 
Rose B said:
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,
Click to expand...

Check to make sure you have the name of the subform control correct on your
2nd form ([qryClientGrpTrips subform]).
 
Darn!!! Thought I had, but clearly not carefully enough.... a copy/paste to
be sure did the trick. Thanks

Stuart McCall said:
Rose B said:
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,
Click to expand...

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