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
Printable View
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
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
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.p...hreadid=199941
Okay guess this would help....