microsoft.public.access

On Oct 15, 4:41 pm, "Ken Snell \(MVP\)"
wrote:
> 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
>

There's a group of forms, frmMainGoals, fmrLevel2Goals,
frmLevel3Goals, etc. On those forms there is a button which opens
frmBudgetForm. There's no reason why the budget total can't be
calculated each time you open frmBudgetForm, but the client would like
to see the total on frmMainGoals (etc.). If it's not possible then
that's fine too, I can explain to him that it's not possible.