HiHiHi,

I want to check a value in the next record of a recordset. I had
intended to use the DLookup function, but I cannot figure out how to
have the module know what the next record is.

The lookup is occuring deep in a nested Do.. While Loop.

The recordset used is the result of a query. This recordset may have
one record, or it may have 100 records in it.

I do not care how, but I want to base operations on one record on the
value in the next record.

Also, does anyone know of good information on Access Cursors (like
MSSQL Cursors)?

thanx

V.
*****
I never >try< anything
I just do it.

Wanna Try Me?
*****

try something like this:

...
do while not rs.eof
    mark=rs.bookmark
    rs.movenext
    [do whatever u wanna do with this "next" record]
    rs.bookmark = mark
    [do whatever u wanna do with this "current" record]
    rs.movenext
loop

--

='='='='='='='=
Mario Osorio
='='='='='='='=