I have created a form with a sub form and on the sub form i had the following

Name (Combo box)
Cust ID (Text Box) - Number
Payment (Text Box) - Currency
Total (Text Box) - Currency

I have used the COLUMN property of the combo box as the control source for the other fields.

However when I enter
=sum([Payments]) as the control source for Total I get an error.

Can anyone help me with this problem

Thanks in advanced

Andy

First, is it Payment or Payments?
Second, The control that is bound to the Payment field should have a unique control name. If the form was built by one of the form wizards, they would have used the field name of the bound field as the control name. Normally this does not cause any problems. But, there are times when it does. So, just change the control name to txtPayment.

Thanks i'll look into it

andy