Dsum on table records

[RealKiwi]

Im trying to the Dsum value from a table, immediately following the addition of data to the new record's last field: Amount. For reasons unknown to me, the Dsum only sums across other table records, and does not include the newly added record.

What is the accepted workaround for this problem?

Here is the Dsum calculation:

intSumItemDrops = DSum("[dp_AMT]", "tblOrderDrops", "[dp_ITMID] = " & vOrderItem)

TAA
RK

 

[RealKiwi]

Solved my own problem -- just forced a form recalc before doing the Dsum:

Me.Recalc

It would be nice to know why it wasn't working, but my guess is it's something to do with "dirty" records??

RK