"rowset does not support scrolling backwards" in Access2000
Posted on 2004-09-13
I keep on getting "rowset does not support scrolling backwards" on the rst.Find. When I hit "Debug" to get to that line in the code and F8 to run it again, it executes, but goes to EOF. Before the F8, EOF and BOF are false, and the record set is, in fact, at the first record. I know for a fact that the record searched for is there. And if it weren't, it would just go EOF. Here's the code.
If rst Is Nothing Then Set rst = New ADODB.Recordset
If rst.State <> adStateOpen Then
rst.CursorLocation = adUseClient
If Recordset!SOURCE = "COUNTY_NM" Then
rst.Open "SELECT * FROM county_nm", CurrentProject.Connection, , adLockOptimistic
rst.Open "SELECT * FROM permits_nm", CurrentProject.Connection, , adLockOptimistic
If Not (rst.BOF Or rst.EOF) Then
strFind = "ADDRESS='" & Me.ADDRESS & "'"
If Not rst.EOF Then
' record is found and load it.