When you create your Recordset you're not spcifying what type of Cursor to Create.
The Default is adOpenForwardOnly which is a Single Pass, (One Way Only), Read Only Cursor.
Therefore the MoveFirst, MoveLast and MovePrevious Methods won't work.

It's primarily used for Lookups requiring ReadOnly Data, because it's so much faster.

Try Specifying adOpenKeySet instead.

------------------
Aaron Young
Analyst Programmer
[email protected]
[email protected]


[This message has been edited by Aaron Young (edited 11-19-1999).]