Calculated field showing #Error

Question

Hello,

I have a field that I used to calculate a time duration to the nearest half hour.  The calculation works fine, but the calculation is done on a subform, and I have to refer to the calculated field from the main form, I which I do by setting the control source of a text field to the calculated field on the subform.  My problem is that I keep getting that #Error on the field on the main form.

So I set the control source of the text box on the main form as follows -=[Activities].[Form]![txtSum2]

---

olu Solaru

Answer 1

What is the name of your sub form? Is it the same as the name of the sub form control?

---

Bill Mosca
www.thatlldoit.com
http://tech.groups.yahoo.com/group/MS_Access_Professionals

Answer 2

the syntax for calling a control on the main form (from a control on the subform) is:

=Parent.ControlName

Answer 3

To get the value of a control on a subform to show on the main form, you do it like this:

ControlSource in properties box

=[subform control name]![control name]

For example, if the subform control is named Customers1 and the text box on the subform is named Company

=[Customers1]![Company]

---

Bill Mosca
www.thatlldoit.com
http://tech.groups.yahoo.com/group/MS_Access_Professionals