how do i specify the options for the command object so that it is scrollable for using find function of recordset later on ...

eg.
objComm.CommandText="SELECT MsgID FROM Message WHERE ReceiverID" _
                    "LIKE '" & Session("TenantID") & "' ORDER BY" _
                    "MsgDate DESC"
Set objSurround = objComm.Execute
objSurround.Find = "MsgID = " & Request.QueryString("MsgID")

this gives an error that the recordset isnt scrollable .. how do make it scrollable ...

:(hey someone help me out ...

Hey!

To get you started, look into the cursor you are creating.
And also think about using the recordset object directly without
using the command object at all.

At first glance I am guessing that the problem is to do with the fact that the recordset returned cannot be traversed.
Such as in a Forward Only cursor...and I think...that the default for the command object is such a cursor....?

Try using the objSurround.Filter = "MsgID = " & Request("MsgID") instead to shrink the recordset temporarily.

If this doesn't work you will probably need to change the cursor you are using....along with the using the recordset object instead of the Command object so that you can specify the cursor type to use.....and also look into the way you are connecting to the datasource to make sure that the provider {driver} supports the features you're intending to use.

see how you get on....

Set these properties on the recordset object before you do the Execute:
.CursorLocation = 3 ' adUseClient
.CursorType = 3 ' adOpenStatic

Just wondering, why don't you just add the MsgId you want to the WHERE clause of your SQL statement?