Seek Method LockType Property AbsolutePosition Property MoveComplete Event WillChangeRecordset Event WillMove Event PROPERTY:  Recordset::Index string = recordsetobject.Index recordsetobject.Index = string The Index property sets or returns a string value that refers to the name of the current index for a Recordset object. This current index must have been previously created either as an index on the base table or an ADOX Index object. The basic concept is to create an indexed display of the records and to use the companion Seek method to search these indexed records. Few providers support this property. You can set this property on an open or closed Recordset object. Note that you can always successfully set this property when the Recordset is closed, but if the provider does not recognize this property, the Recordset will not open properly. If you try to set the Index property on an open Recordset and the provider does not recognize this property, an error will be generated. Code (VBScript): If objRecordset.Supports(adIndex) Then    objRecordset.Index = "AddressIndex" End If Copyright 1999-2001 by Infinite Software Solutions, Inc. All rights reserved. Trademark Information