Getting Val of a Val field

[bgeorge12]

Yes the sub form runs by itself. That is the only way I can see the Total in the footer.

[RuralGuy]

The file you posted does not have a SubForm that runs by itself without errors.

[bgeorge12]

I forgot that I changed from a dlookup as source code for Price to a code. I see that it does not work on it's own now because of the way I wrote the code I think. But before I changed it I still could not get the value of text14 to show up on the main form footer.

[RuralGuy]

How about with this db?

[bgeorge12]

Thanks but that doesn't work. How about if I skip totaling on footer of subform and go straight to main form footer for the running total? Tryed:
=Val(Forms![Order Details]![Subform Orders]!form![Price]*[Quanity])
but this doesn't work. Any suggestions?

[RuralGuy]

What do you mean my db "doesn't work"? Don't you get a value in the MainForm now?

[bgeorge12]

I used your source code in my database (changing the names to fit this db) and I still get #name? I see that it works in your database but I think the difference is that your text field has an interger in it where mine is a calculated field.
I want to thank you for the time you are putting into this. I do appreciate the help.

[RuralGuy]

I will have to disagree with you on using a control with a calculation in it.

[bgeorge12]

Thank you, thank you. And thanks for your patience with me!