dsum - easy question

[Onslaughtdave]

Hi,

Im tring to run the dsum function thru the form_current() trigger.

The problem im having is that i get the vba error:
" Run-time error '2001':
You canceled the previous operation"

here is the code im running:
curTot = DSum("[cost1]+[cost2]+[cost3]+[cost4]", "table1", "table1![ANum] = table2![ANum]")

is this the proper way to reference a table in a DSum?

I am running this on a form, if that makes any diferences...


thanks,

dave

 

[PHV]

How the DSum could know this value (table2![ANum]) ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[Onslaughtdave]

It is just an example without have to use the actual table names...

sorry for any confusion