Sum a column every time a record is created

[ecnalch]

I want to sum the Quantity field each time I create a record. I am defaulting
a 1 in the Quantity field and I have created a sum in the footer section. The
sum works whenever I manually enter a value but it does not work if I use the
default value of 1. In other words, if I simply press enter and accept the
default 1 for quantity, the sum does not update when I commit the entire
record. If I manually enter a value of 1 for Quantity it does update. How can
I force the sum to update each time I create a record even if I do not
manually enter a value?

 

[Arvin Meyer [MVP]]

Try forcing the subform to recalculate in the AfterUpdate event.

Sub Form_AfterUpdate()
Me.Recalc
End Sub
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access