Show subform total on main form

[Guest]

I have a sub form with the fields Qtt and UCost.
On this form footer I have a calculated field: TotalCost=sum(Qtt*UCost)
On the main form I have a calculated field: ICost=TotalCost

The field on the main form is not working. It shows “?name†error.

Any suggestions?

 

[kingston via AccessMonster.com]

Change the Control Source for the field in the main form to something like:

=DSum("[Qtt]*[UCost]",[SubForm].Form.RecordSource)

I'm assuming you don't want this in the subform (i.e. you don't need to have
the calculated field in the subform).

 

[Al Campagna]

Raul,
Try...
= Forms!frmMainFormName!frmSubFormName.Form!TotalCost

--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."

 

[Al Campagna]

The OP wrote...

On this form footer I have a calculated field: TotalCost=sum(Qtt*UCost)

So... the ICost field on the main simply has to call that existing subform value.
--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."

Change the Control Source for the field in the main form to something like:

=DSum("[Qtt]*[UCost]",[SubForm].Form.RecordSource)

I'm assuming you don't want this in the subform (i.e. you don't need to have
the calculated field in the subform).

I have a sub form with the fields Qtt and UCost.
On this form footer I have a calculated field: TotalCost=sum(Qtt*UCost)
On the main form I have a calculated field: ICost=TotalCost

The field on the main form is not working. It shows "?name" error.

Any suggestions?

 

[Guest]

Thank you both for your reply.
I could not use Dsum because I need the filed to be immediately updated.
At the end Al Campagna approached worked. A had tried it before with no
success. Maybe it was a syntax problem.


"Al Campagna" escreveu: