After TableUpdate() you can't undo changes using TableRevert().
About refreshing the controls:
FOR nControls = 1 TO thisform.ControlCount
thisform.Controls(nControls).Refresh()
NEXT
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.