---

can anyone please tell me why I get the following error: "Operation is not
allowed in this context." when doing a "record.MovePrevious" in a recordset.
the recordset is opened in the following way: "Rs.Open "DRIVER={Microsoft
Access Driver (*.mdb)};" & DBPath,adOpenStatic"

-Kent

---

It is because of the way the recordset is opened. It is MoveForvardOnly.

I have had the same problem, and I could not solve the problem with MS SQL
server, so I think it's the same with access.

Maybe you could put the current record in a session variabel and check the
next record before you print the session variabel. That way you solve moving
previus once....


Rasmus

> can anyone please tell me why I get the following error: "Operation is not
> allowed in this context." when doing a "record.MovePrevious" in a
recordset.
> the recordset is opened in the following way: "Rs.Open "DRIVER={Microsoft
> Access Driver (*.mdb)};" & DBPath,adOpenStatic"
>
> -Kent
>
>