microsoft.public.access

wrote in message
news:1192479000.018892.169650@t8g2000prg.googlegroups.com...
> On Oct 15, 3:46 pm, "Ken Snell \(MVP\)"
> wrote:
>> OK - I've reread your post, and let's try this:
>>
>> =DSum("Amount", "tblBudget", "[BudgetGoalNumber] Like '" &
>> [BudgetGoalNumber] & "*'")
>>
>> --
>>
>> Ken Snell
>>
>>
>> wrote in message
>>
>> news:1192476972.323283.170350@q5g2000prf.googlegroups.com...
>>
>> >> > I tried that and am only getting #Error in the new text box. The
>> >> > subform is in datasheet view, does this have anything to do with it?
>>
>> > I'm still getting the error. Could this have anything to do with the
>> > fact that the subform and the form have different recordsources?
>
> Oh that's fantastic. So that total is not saved anywhere, right? I'm
> wondering if it's possible to get that total amount listed on a
> different form.
>

You'll need to provide more details about "different form" in terms of what
the form is, is it open while your current form is open, etc. But is there a
reason why you can't just calculate that sum whenever you want to show it?
--

Ken Snell