Error in field

[Guest_imported]

HI,
i have a cute little form that is a petty cash voucher.
the mainform is linked to a subform. The subform has the fields; date,description, amount.
On the main form I have a field that i want to reflect the total amount of the entries in the subform.
So . . . on the main form in the "total" field the field,s control source is

=Sum([Forms]![frmPettyCashsub]![Amount])

But the word "Error" shows up in this field when viewing the form.

any ideas on how to correct this??
thanks in advance and happy fourth!!!!

 

[mdillon]

Go to the design view of your subform. In the footer of the form, create a text box called SubTotal. The control source becomes "=sum([Amount])" without the quotes. Now on the mainform, create another text box. Set the contol source in it to be: "([frmPettyCashsub].Form!SubTotal" without the quotes. This worked when I got a similar error.

M. Dillon

 

[Guest_imported]

sweeeeeeeeeeeeeeeeeet