Error Source Property Record Source Property PROPERTY:  Recordset::Source string = recordsetobject.Source recordsetobject.Source = string Set recordsetobject.Source = variant The Source property can set either a string value or a Command object reference to specify a data source for a Recordset object, or it can return a string value that identifies the data source for a Recordset. You can only set the Source property if the Recordset object is closed. If the source is a Command object, then the ActiveConnection property of the Recordset object inherits the value of the ActiveConnection property of the Command object. The string can invoke an SQL statement, a stored procedure, or a table name. Code (VBScript): rsChants.Open strQuery, , , adCmdTable ... strCommand = rsChants.Source Copyright 1999-2001 by Infinite Software Solutions, Inc. All rights reserved. Trademark Information