trying to store a valu from a subform in main form

[aguest]

Hi,

Can someone tell me why this isn't working for me please. I'm getting a #name? error in my text box in the footer (doesn't matter where this is placed on main form. I've changed this to be forms. and forms! but no difference in the outcome.

I just want it to view the total figure from a purchase order subform. This is populating correctly but isn't being stored anywhere, just shows.

Also, any way I could make this invisible when the form is in form mode?

Thanks in advance.

 

[pbaldy]

Are you referring to the subform correctly? Can't tell from the picture:

http://www.mvps.org/access/forms/frm0031.htm

 

[aguest]

Hi pbaldy,

Thanks for that I've looked thorugh the sheet and it looks like I'm referring to it correctly. The text box in the footer has the following in it :=[Me]![txtTotalCost].[frmEquipPurchaseOrderSubform]![txtEqTotal].

It's still giving me the same error.
Any suggestions?

 

[pbaldy]

For starters, "Me" is only valid in VBA code, so that would cause an error. txtTotalCost is the name of a form?