Command State Property Connection State Property Recordset State Property Streamt State Property PROPERTY: Record::State Implemented in version 2.5 long = recordobject.State   The State property returns a long value that is the sum of one or more ObjectStateEnum constants. These constants describe if the Record object is open, closed, or executing. The adStateConnecting and adStateFetching constants are not used. The default value is adStateClosed. You can call the State property at any time.   ObjectStateEnum Constants   Constant Value Description adStateClosed 0 Object is closed adStateConnecting   Not used adStateExecuting 4 Object is executing adStateFetching   Not used adStateOpen 1 Object is open   Code (VBScript): If objRecord.State = adStateOpen Then    objRecord.Close End If Copyright 1999-2001 by Infinite Software Solutions, Inc. All rights reserved. Trademark Information