SubForm Update

[libraccess]

I have a continuous subform that has a calculated field ( a running total)
At the moment this calculation does not happen until I enter the next row (record)


Now I thought it would be clever to avoid the Ctrl Tab to exit to have a button as the last control so Tab moves to the next row Enter Exits. Works Well
I want to update the calc field I tried this (tried it on the control (SubVol) that Im calcing on) and then on the exit button

Private Sub btnNewRec_GotFocus()
Forms!frmMainDel!frmSubDel.Requery
End Sub
And I receive this - you must save the current field before you requery
help please

[June7]

Try doing the save just before requery:

DoCmd.RunCommand acCmdSaveRecord

[libraccess]

Done!!!
SuperModerator is Not enough
I'd rename you SupercalifragisticExtremerator