I have 2 txtboxes on a form : DolAmt & TotDolAmt.
Dolamt is user entered, TotDolAmt = Sum(DolAmt).
I would like to test that TotDolAmt has a certain value before closing the form.
My problem is that TotDolAmt is not being recalculated to include the value of the record that was most recent.
I have to move to another record or close then reopen the form in order for it to work.
I tried Me.Recalc, but it didn't work.
I tried
DoCmd.RunCommand acCmdSaveRecord
Me.TotDolAmt.Requery
before DoCmd.Close but it didn't work.
Any suggestions would be most welcome!!
Thanks!
Dolamt is user entered, TotDolAmt = Sum(DolAmt).
I would like to test that TotDolAmt has a certain value before closing the form.
My problem is that TotDolAmt is not being recalculated to include the value of the record that was most recent.
I have to move to another record or close then reopen the form in order for it to work.
I tried Me.Recalc, but it didn't work.
I tried
DoCmd.RunCommand acCmdSaveRecord
Me.TotDolAmt.Requery
before DoCmd.Close but it didn't work.
Any suggestions would be most welcome!!
Thanks!