calculated field not updating

[parkfairfax]

Help! I have 2 calculated fields on my form.., they seem very simple.

= Sum([Actual Cost]) and =34000-Sum[[Actual Cost]). These are in the control source line of the properties box.

...Where the first expression totals all by expenses, the 2nd expression subtracts my total expenses from my budget to give me my remaining balance. These 2 text box controls are in my form footer.

The first time I placed these boxes in my footer and defined the calulated fields it worked fine..., all my expenses were totalled, and the new balance was displayed.

But, when I tried to tried to add a new record to my database or change the expenses in any of the existing records the calculated controls did not update.

Can anyone tell me how to fix this and/or why things aren't updating? Thanks ---gm

 

[jebry]

Hi!

You might try using DSum("Actual Cost", "YourTableName&quot in place of the Sum.

hth Jeff Bridgham
bridgham@purdue.edu

 

[BoxHead]

If [Actual Cost] is a control you're adding data to when you create the new record, you would have to requery.

On the AfterUpdate event for ActualCost,

  txtSum.Requery
  txtCost.Requery

Substitute your control names for txtSum and txtCost.


HTH

John

Use what you have,
Learn what you can,
Create what you need.