Connection Errors Collection Requery Method Record UnderlyingValue Property METHOD:  Recordset::Resync recordsetobject.Resync  AffectRecords, ResyncValues The Resync method is used to re-fetch the data from the underlying data source and to update (resynchronize) the values in the current Recordset. Since this is not a re-query, new records in the database will not be added to the Recordset. If you call this method on a server-side Recordset, you will get an error. Likewise, you cannot use this method on client-side, read-only Recordset objects. If the call to this method fails because of conflicts with the underlying date (such as a record having been deleted), warnings will be returned to the Errors Collection and a run-time error will be generated. This method has two optional parameters. The optional AffectRecords parameter is one of the AffectEnum constants that specifies which records are to be affected. The default is adAffectAll. AffectEnum Constants   Constant Value Description adAffectAll 3 Cancels all pending updates including those hidden by a filter adAffectAllChapters 4 Cancels all pending updates in all child (chapter) recordsets adAffectCurrent 1 Cancels only the current record adAffectGroup 2 Cancels updates only on records that passed through the filter in effect   The optional ResyncValues parameter is one of the ResyncEnum constants that determines which values can be overwritten. The default is adResyncAllValues.   ResyncEnum Constants Constant Value Description adResyncAllValues 2 Default, can overwrite all values, and pending updates are cancelled adResyncUnderlyingValues 1 Can only overwrite underlying values, and pending updates are not cancelled Code (VBScript): objRecordset.Resync adAffectAll Copyright 1999-2001 by Infinite Software Solutions, Inc. All rights reserved. Trademark Information