Theresa said:
The Subtotal text box is in the footer of the subform.
Okay, fine.
The control source for Total Watts =[Fixture_Qty]*[Watts]
Ah , so following the rule I mentioned earlier, at the very least you're
going to have to change the controlsource of Subtotal to:
=Sum([Fixture_Qty]*[Watts]*[Annual_Operating_Hours]*[Rate KWH]/1000)
The Sum() expression can't refer to controls on the form, only to fields in
the form's recordsource.
But the above revised controlsource may still not work, because of these
things you mentioned:
Annual Operating Hours is a lookup field to the operating hours table
Rate KWH is a manually entered field.
In both cases, I'm not sure what you mean. When you say "Annual Operating
Hours is a lookup field", what do you mean? Is it in the form's (subform's)
recordsource, or are you saying that it's a calculated control whose
controlsource is, maybe, a DLookup() expression?
When you say "Rate KWH is a manually entered field", do you mean that it's
an unbound text box on the form, and thus not in the form's recordsource?
--
Dirk Goldgar, MS Access MVP
www.datagnostics.com
(please reply to the newsgroup)