Requeries the ODBC data source specified in the Connect property and updates the query results.
Syntax
AdvancedDataControl.Refresh
| Part | Description |
| AdvancedDataControl | An object variable that represents an AdvancedDataControl object. |
Applies To
Remarks
You must set the Connect, Server, and SQL properties before you use the Refresh method. All data-bound controls on the form associated with an AdvancedDataControl object will reflect the new set of records. Any pre-existing Recordset object is released, and any unsaved changes are discarded. The Refresh method automatically makes the first record the current record.
It's a good idea to call the Refresh method when you work with data. If you get data, and then let it sit on your client machine for a while, it is more likely to become out of date, and it's possible your changes won't go through because someone else would have changed the record before you.
See Also
CancelUpdate Method, SubmitChanges Method, Address Book Command Buttons, Using AdvancedDataControl to Pass Updated Recordsets to the Middle Tier
© 1997 Microsoft Corporation. All rights reserved. Terms of Use.