Moving Next/previous

[parkes]

Can someone tell me how to move backwards and forwards through a record set. Also to tell my which record I am on 3 of 1500, etc

[monte96]

Make sure that your recordset is not forward only and you have MoveNext, MovePrevious, MoveFirst, MoveLast, and Move n methods available to navigate through a recordset. If you must know which record you are on (really you only need to know if it's the first or last to handle EOF and BOF) you can use the AbsolutePosition property which returns the record's ordinal position in the recordset.

For more info check this out on MSDN Online (http://msdn.microsoft.com/library/officedev/off2000/acproabsolutepositionx.htm)

[JohnSmith]

Did you ever get the answer to this question? I am trying to do be able to navigate through the recordset: see thread:

http://www.vbforums.com/showthread.php?s=&threadid=199941

[veryjonny]

Okay guess this would help....