I just a simple textbox in a subReport, and I set the control source to be ="Mean="&[C1 Mean Value],[C1 Mean Value] comes from a table called tblC2. But it turns out to be an error in this textbox(see below):

ID Mean Value Comment
1 Error ......
2 Error ......

It dosen't come up with an error box but just has error in that specific field in the report. Any idea? Thank you very mcuh

Questions:

1) Is the subform bound or UNbound?

2) If the subform is unbound, then you need to look up the value of [C1 Mean Value], perhaps using a DLookUp function, e.g.

="Mean=" & DLookUp("[C1 Mean Value]", "tblC2", "[Some Other Field] = " & Me.AnotherTextBox)

3) Why do you set the textbox value to be

="Mean=" & [C1 Mean Value]

instead of just having the LABEL say "Mean =" and having the TEXTBOX just set only to

=[C1 Mean Value]



Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

thx so much, one more stupid question: how to know wheather it is bound or unbound?

Take a look at the Record Source property of the subform in Design View.


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

Check the propery for the textbox and make sure that the name is not the same as the field name of [C1 Mean Value] used in the calculation. If it is you will need to change the name fo the text box to soemthing that does not make a field name in the report's record sorce.

Boyd
"Hi Tech Coach"
Access Based Accounting/Business Solutions developer.
http://www.officeprogramming.com