Hi Guys
I'm getting this error when I loop through a record set. I am connecting to a Stored Procedure that performs the search on my database. I can retrieve the first five set of records and then when there is no more data left in the table I get the following error.
The Rowset was built over a live data feed and cannot be restarted
Here is my loop
Code:
Do While objRS.EOF = False
Call MsgBox((objRS.Fields(0) & vbNewLine & objRS.Fields(1) & vbNewLine & _
objRS.Fields(2) & vbNewLine & objRS.Fields(3) & vbNewLine & objRS.Fields(4)), vbInformation)
objRS.MoveNext
Loop
objRS.MoveFirst
Can someone please help me
JK