Hello

How can I display my updated field when I move to another record
I read that I must use the "Resync Command"


Private Sub Texte498_AfterUpdate()
Dim strsql As String
Dim MonthAmt As String
strsql = "update tblInfo set MonthAmt=Texte498.text where (((tblInfo.MonthNum) = '1') And ((tblInfo.Rub) = 'FEAD') And ((tblInfo.ProdNum) = ProdNum.value))"
DoCmd.RunSQL strsql
End Sub


strsql = "update tblInfo set MonthAmt=Texte498.text where ..."

Is this Ok or not ???

Where can I put the Resync Command within this code

THANKS


RAJIV



update tblInfo set strsql = "update tblInfo set MonthAmt=Texte498.text