Unanswered: SUBFORM IN CONTINUOUS FORM with TOtal function
I've been beating my brains out on this for quite awhile. I have a subform attached to the mainform in continuous form. I inserted a text box at the footer bound to subform which returns a SUM calculation (=SUM(txtSubTotalAmt) but when i set it to the form view i got an error. I tried the dSUM function but still i got an error. I know there might be problem somewhere between the subform or in the continuous form but i cant figure out which one is giving the error. Any help is appreciated. Thanks!
The problem on subform in continuous form with a TOTAL function has been solved already (thank you very much!). For example: I have a main form which contains the name of the costumer and a subform which contains the goods he purchsed with a total function at the footer like the one I stated above. Now I want all the fields be cleared with records from the mainform and subforn when I click the "add new record" at the navigation button. Please help!