How Do I Display SubFormTotal on Main Form

  • Thread starter Thread starter JustMe
  • Start date Start date
J

JustMe

Hi All
Can anyone suggest why this might be happening?

I have the following line in a MainForm

=[InvoiceMainPartsSubForm].Form![SubFormTotal]

for pointing to a calculated field on a subform. All I am trying to do is
get the amount from the SubForm to The Main form.
Each time I try to save this It ALWAYS ends up with this...

=InvoiceMainPartsSubForm.Form!SubFormTotal

and I get the stupid #Name? error message.

Would some one Please explain to me why the brackets disappear each time I
go to save it? And How I should do this?
Thanks
 
Leave brackets off of SubFormTotal. Also double check your control names
spelling.

Damon
 
Back
Top