sum text box porblem

G

ghost

Hi,
I have a text box for sum a group of text box in sub form. When I run the
form, it works. But when I run the form using another form†run the form from
other form by using a button†the sum text box does not work. Can any body
tell me what is wrong?
your help is highly appreciated.
thx.
 
W

Wayne-I-M

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
 
G

ghost

hi,
here is the fomula as per your request.
=Sum([No of Task])
the formula is in a text box at the subform footer.
 
Top