MSHFlexGrid plz. HELP !!!!!!!!1

[ctudose]

I have an Access97 db & ABC a query
I use the following code code to display the results into an MSHFlexGrid.
Why is it displayed JUST the first record ????
What is it wrong ???


Private Sub cmdReport_Click()

Dim rs As ADODB.Recordset
Dim cmdobj As ADODB.Command


Set rs = New ADODB.Recordset
Set cmdobj = New ADODB.Command

With cmdobj
.ActiveConnection = cnx
.CommandText = "ABC"
.CommandType = adCmdStoredProc
End With




Set rs = cmdobj.Execute()

Set Me.MSHFG.DataSource = rs



End Sub

 

[zemp]

What is your stored proceudre, what does it return in Access? Thanks and Good Luck!

zemp

 

[Guest_imported]

the problem is that Execute method return a recordset which is by default adOpenForwardOnly and I think here is the problem- for Access97;
For a sql stored procedure it works.
So, to solve the problem I had to use the Open method
Anyway, thanks
Regards,
cris