Hi guys, I'm having difficulty with navigating a recordset, hopefully someone out there can point me in the right direction.

I have 4 links that will allow a user to view the First, Previous, Next, and Last record in a recordset,

When a button is clicked it reloads the page and send through the querystring a value of first, previous, next, or last.

I use these values in an If statement, as follows...
Location is the name of a variable that (believe it or not) holds the exact location of the recordset.

In my adovbs.inc file I have set adOpenForwardOnly = 1

MoveNext, and Movefirst both work fine, but movePrevious and MoveLast have different errors, they are...

movePrevious => Wrong number of arguments or invalid property assignment: 'Rs.MovePrevious'
moveLast => Rowset does not support fetching backward.

Any help here would be much appreciated.

Cheers,

Blaise

instead of using adOpenForwardOnly...
try adOpenStatic or adOpenDynamic...
im not exactly sure which would be best but...

this will allow you to move around the record set in any way you want..
adOpenForwardOnly only allows forward movement

hope this helps

I don't have my books with me right now, so this may not be quite correct.

I think the problem is with how you defined the cursor. By setting it to adOpenForwardOnly you create a cursor that cannot move backwards (hence why it says "ForwardOnly" :D).

Instead, try setting it to adOpenStatic.

Bruce Luckcuck
Director, Applications & Support Services
Wiley Publishing, Inc.

I also have the other two Constants declared, they are set to...

Const adOpenDynamic = 2
Const adOpenStatic = 3

I'm not entirely sure what the values 2, and 3 mean, I've tried looking about, but can't seem to find anything, I find the Microsoft site really damn confusing.

These are just ado constants...
they are given names like adOpenForward only so that is is easier to understand what they do...
for example..
objRS.CursorType = adOpenForwardOnly
is easier to understand than
objRS.CursorType = 0

I just realised I was getting confused, thinking that the constants were switches, but are infact variables, so I eventually opened my recordset as a dynamic recordset, and it works fine now, thanks for giving my brain a jig, I needed it.

If you guys know where I can get some good online information about these ADO variables, could you let me know.

Cheers,

Blaise

http://www.devguru.com/Technologies/...ado_intro.html