Total on subfrom to mainform

[chopper7898 via AccessMonster.com]

I've done this before, but it's not working on the main form. I keep getting
#Name?
The MainForm and Subform are not linked, would that make a difference?

I have a Datasheet subform inbedded in a Mainform so I can have room for
command buttons to open reports.

I place an unbound box in the footer of the subform to total project costs
and placed another on the mainform to show it.

Subform footer: name of unbound "ProjectTotals" control source =Sum([Cost])
Unbound on Mainform: =[sfrm_ProjectsDatasheet].Form!ProjectTotals

 

[Allen Browne]

Looks right. The linking won't cause the problem.

Perhaps the Name of the subform control is different than the name of the
form you load into it (its SourceObject.) Open the main form in design view.
Right-click the edge of the subform control, and choose Properties. What is
its Name (on the Other tab of the Properties box)?

 

[chopper7898 via AccessMonster.com]

Thanks Allen. I had already done that several times. I just got it to work.
I didn't think that it mattered but I changed the title of the subform after
I placed it on the MainForm, but the property showed the new name of the
subform so I thought it was OK, but I guess not. I deleted the subform and
reinstalled it again on the MainForm and the Total box works.
Thanks again for your help, that was very nice of you providing a quick
response.

Looks right. The linking won't cause the problem.

Perhaps the Name of the subform control is different than the name of the
form you load into it (its SourceObject.) Open the main form in design view.
Right-click the edge of the subform control, and choose Properties. What is
its Name (on the Other tab of the Properties box)?

I've done this before, but it's not working on the main form. I keep
getting

[quoted text clipped - 10 lines]

=Sum([Cost])
Unbound on Mainform: =[sfrm_ProjectsDatasheet].Form!ProjectTotals