MoveNext??

[lukePas]

I've been trying to create code that allows me to move through the selected records using the ADO tool
(Other than using the buttons provided with the ADO tool)
Any idea - please let us know
Thanks

[Dragev]

Is this what you mean?

Data1.RecordSet.MoveNext

D

[lukePas]

yep - thats exactly what I was wanting - Thanks heaps

Hi there, this code should do to help navigation.


Next Record :

if not recordset.recordcount = 0 then
recordset.movenext
if recordset.eof = true then
recordset.movelast
end if
end if

Previous Record :

if not recordset.recordcount = 0 then
recordset.moveprevious
if recordset.bof = true then
recordset.movefirst
end if
end if

Last Record :

if not recordset.recordcount = 0 then
recordset.movelast
end if

First Record :

if not recordset.recordcount = 0 then
recordset.movefirst
end if


This should do for navigating through any recordset supporting navigation. if you still have problems, you can be more specific about them and feel free to mail me. all the best...vijay