Hi, I am going to be searching for a record in the db.I am using the recordset.find method to search through the data.
Heres the code..

Dim cnClientdata As ADODB.Connection
Dim rsClientdata As ADODB.Recordset
Dim sFindCriteria As String

Set cnClientdata = New ADODB.Connection
Set rsClientdata = New ADODB.Recordset

sFindCriteria = "clientphone like '" & _
Phonenum & "*'"


With cnClientdata
.Provider = "SQLOLEDB"
.ConnectionString = "User ID=user;Password=user;" & _
"Data Source=user;" & _
"Initial Catalog=user"
.Open

End With

*When this line gets executed, I get an error: COMMAND TEXT NOT SET *
* What does this mean ? *

rsClientdata.Open , cnClientdata
rsClientdata.MoveFirst
rsClientdata.Find SearchCriteria, , adSearchForward

Thanks
Niv