Scrolling RecordSets 1

[Rougy]

Hi,

I've noticed that the recordset object has a "moveprevious" method, but every time I've tried to use it, it wouldn't work.

Is there a setting I'm not using right?

There are ways around it, but it would be really handy to scroll back one recordset in some cases, especially regarding data associated with dates.

Thanks.

-----
The death of dogma is the birth of reason.

 

[CajunCenturion]

You may be opening your recordset with a forward only cursor. Look into the Dynamic and Static cursor types and see if either of those might help out.

Good Luck
--------------
As a circle of light increases so does the circumference of darkness around it. - Albert Einstein

 

[Rougy]

rs.Open CMD1, cn, adOpenStatic

"adOpenStatic" was the magic word.

Thank you!

-----
The death of dogma is the birth of reason.