Getting Val of a Val field

[bgeorge12]

I have a field that calculates a total on the subform. This field is in the footer of subform and is named txt14.



=Val(Forms![sbfOrderDetails]!Price*[Quanity])

I would like for a field in the main form footer to copy the amount in txt14. I tryed = txt 14 and Val txt 14 and neither work. Please help. Thank you

[RuralGuy]

Here's the answer in a link: http://access.mvps.org/access/forms/frm0031.htm

[bgeorge12]

That is a great link and very informative, but it doesn't work. I have:
=[Forms]![Order Details]![sbfOrderDetails].[Form]![Text14]
and the text box says #name? Did I miss something?

[RuralGuy]

Double check the SubFormControl name. It need not be the same as the SubForm it is displaying. =[Forms]![Order Details]![sbfOrderDetails].[Form]![Text14]

[bgeorge12]

Checked. The name is correct.

[RuralGuy]

Just change it to: =sbfOrderDetails.Form.Text14
...and eliminate going through the Forms collection.

[bgeorge12]

Sorry just tryed that and no change. Is there some way I am suppose to be referencing that text14 is located on the formfooter of the subform?

[RuralGuy]

Nope! It should be a unique name for the entire SubForm. Try changing your SubFormControl name in both locations and see if you still have the same error. It would also give this same error if the name was not unique.

[bgeorge12]

Tryed renaming it and still get the same error.

[RuralGuy]

The name of the SubFormControl is on the Other tab of the property sheet for the SubFormControl. Change it to something else and see what happens.

[bgeorge12]

That is where I changed it and nothing new happens. I keep trying various ways to write it and it still says #name?.

[RuralGuy]

Any chance you could post your db or enough of it to expost this problem?

[bgeorge12]

Here is my DB. I had to zip it to get it to fit.

[RuralGuy]

Sorry, but I did not get notification that you posted again. I'll look at your db.

[RuralGuy]

Let's start here: Does your SubForm run by itself and if not, why not?