microsoft.public.access

I have a project for a client that is essentially goals and subgoals,
so for instance, you have goal 1 and subgoal 1.1. I've created a table
tblBudget with fields BudgetLineID, BudgetGoalNumber, Amount and
BudgetCategory (which comes from a separate categories table). I
created a form with a subform to enter the different budget amounts,
it opens from the form which you enter the goals and takes the goal
number as a filter for the budget form. The client would like the
budget to display the sum of all the subgoals, as well as have the
opportunity to enter ine items for that goal.

So for instance, if I open the budget form for goal 1, it has the
subform which I've already created which shows you the line items for
goal 1, and then has another box which has a sum of goals 1.1, 1.2,
1.1.1, etc.

Any hope? Thanks!