How to update DSum w/o closing form?

[James T.]

Access 2000.

I have a query that sums a field called MERGAmount. I took
that query and created an autoform, MERGSUM. I took
MERGSUM and dropped it on an input form, MERG, that points
to the MERGTBL.

When I add new records to the MERG form and close the
form, then reopen it the new total shows up.

Is there a way to update the total without closing the
form?

My goal is to show a running total on the users input form
as they add new records.

Thanks,

James

 

[Wayne Morgan]

1) The updated total won't be available until the new record is saved to the
table since that is where DSum is getting its value from.

2) In the form's AfterUpdate event or, perhaps, its Current event, requery
the textbox or recalculate the form

Me.txtMyTextbox.Requery
or
Me.Recalc

 

[James T.]

I used the Me.Recalc and it worked great! Thanks!!

James