Refresh (database statements) Purpose Refreshes the values in the current rowset buffers. If changes have occurred to the current row in the underlying database, calling the Refresh method will update the local cursor and propagate any relevant changes to bound controls. If you have modified the current values in the rowset buffers, calling Refresh will get a new copy of the original row from the database and overwrite any changes. Syntax DBStatement.Refresh Compliance: Level 2 Example Sub Click()         MsgBox("Update the current record?",FCYesNo, "Update")         If MsgBoxResponse = FCYes Then                 MyStmt.Update   'Update the current record         Else                 MyStmt.Refresh  'Discard changes and return original values         End If End Sub