microsoft.public.access

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.