Can you post the formula you are using as the control source as it may refer
to the main form - and of course - if open the subform on it's own the
reference will not point to anywhere.
Post the formula and someone will no doubt be able to help

Signature
Wayne
Manchester, England.
> Hi,
> I have a text box for sum a group of text box in sub form. When I run the
[quoted text clipped - 3 lines]
> your help is highly appreciated.
> thx.
ghost - 04 Mar 2007 04:51 GMT
hi,
here is the fomula as per your request.
=Sum([No of Task])
the formula is in a text box at the subform footer.
> Can you post the formula you are using as the control source as it may refer
> to the main form - and of course - if open the subform on it's own the
[quoted text clipped - 9 lines]
> > your help is highly appreciated.
> > thx.