Command State Property Connection State Property Record State Property Streamt State Property PROPERTY:  Recordset::State ObjectStateEnum = recordsetobject.State The State property returns a long value that is the sum of one or more ObjectStateEnum constants. These constants describe if the Recordset object is open, closed, or executing an asynchronous operation. You can call the State property at any time. The default value is adStateClosed.   ObjectStateEnum Constants   Constant Value Description adStateClosed 0 Object is closed adStateConnecting 2 Object is connecting adStateExecuting 4 Object is executing adStateFetching 8 Object is fetching adStateOpen 1 Object is open   Code (VBScript): If rsGuruChants.State = adStateFetching Then    MsgBox "Recordset is fetching records", vbOK End If Copyright 1999-2001 by Infinite Software Solutions, Inc. All rights reserved. Trademark Information