error# when I enter =sum([number]) on Form ??

[johncuevas]

hi

I have made a form with 2 subforms. when I try to total a column of
records, i always get error#. I tried this on several columns and get
same error#. I used the unbound textbox .

thanks,

John Cuevas, seattle

 

[Tom Wickerath]

Hi John,

The #Error error value means that Access cannot evaluate an expression:
http://support.microsoft.com/?id=209132

Are you referring to the name of the control, or the name of the field when you are using the Sum
function? You will get an error if you try referring to the name of the control. You might find
this KB article helpful. Although it talks about displaying subtotals from subreports, the logic
should be very similar for displaying subtotals from subforms on the main form:

ACC2000: How to Display and Total Subtotals from Subreports
http://support.microsoft.com/?id=208835


Tom Wickerath
Bellevue, WA.
_______________________________


hi

I have made a form with 2 subforms. when I try to total a column of
records, i always get error#. I tried this on several columns and get
same error#. I used the unbound textbox .

thanks,

John Cuevas, seattle