Total of subform fields

[pbuddy_8]

I have a Bill form and a transaction sub form. It is displayed like this:

Bill No Date


SNo. Particulars Rate Qty Amount




Total Amount


The sno, particulars etc are fileds of subform and all others are in main form. Now what I want is to calculate total of Amount and put it into Total Amount. How do I do this?

Regards,
Piyush

[RobDog888]

Is "Total Amount" on the main form or subform?

[pbuddy_8]

Total Amount field is in the main form

[RobDog888]

Try setting the conttrolsource for the Total Amount field equal to a sum statement
of the field in concer in the subform.

[pbuddy_8]

I have done that. But now there is one more problem. If you remember you told me to make a new form to display the comapny information and then place the bill form in it. Now when I use the code Forms("New_Bill").Controls("Orderkey").value = .... It says it can't find the form New_Bill. It only happens when the New_Bill form is in Main_NewBill form (the one which shows company info). Please help me with this.

[RobDog888]

Could you attach a small screen shot showing the details.