.MovePrevious

[myasin78]

I have two Buttons, one to select next record and one to select previous one.
the next record works, but the previous one doesn't.

the exact error i get "Operation is not allowed in this context" when i hit debug buttion .MovePrevious gets highlited in yellow which is the problem.

here is the two function that i am using.
i appreciate any help.


Private Sub cmdMoveNext_Click()
With Rs1
If Not .EOF Then
txtoutput.Text = Rs1.Fields(0)
txtpatent.Text = Rs1.Fields(1)
txtserial.Text = Rs1.Fields(2)
listbox.AddItem Rs1.Fields(0)
.MoveNext
Else
MsgBox ("End of File&quot
End If

End With

End Sub
Private Sub cmdMovePrev_Click()

With Rs1
If Not .BOF Then
txtoutput.Text = Rs1.Fields(0)
txtpatent.Text = Rs1.Fields(1)
txtserial.Text = Rs1.Fields(2)
.MovePrevious // here is the problem //
Else
MsgBox ("Begning of File&quot
End If
End With
End Sub

 

[PHV]

This depend on the cursor type.

Hope This Help
PH.

 

[myasin78]

What do you mean by a cursor type.
could you be more specific.

thanks,

 

[SkipVought]

Post the code where you opened your recordset.

Skip,

http://www.TheOfficeExperts.com

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[myasin78]

Public Rs1 As New ADODB.Recordset
Public dbConn As New ADODB.Connection
Public strSql As String

strSql = "SELECT Docket,patentno, serialno FROM Patent"
Rs1.Open strSql, dbConn

 

[BrianLW]

If you are at the first record in the recordset, you cannot move to the previous one.

-B

 

[PHV]

To allow browsing thru the RecordSet, your CursorType must be either adOpenDynamic (2)or adOpenKeyset (1), e.g.:
Rs1.Open strSql, dbConn, adOpenKeyset

Hope This Help
PH.

 

[SkipVought]

the default cursor is adOpenForwardOnly

Skip,

http://www.TheOfficeExperts.com

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[myasin78]

I am not at the begining of the record, i did go forward first, then tried to go backward.

I am also checking for .BOF

thanks anyway.

 

[Tranman]

If this is a linked table, some ODBC sources don't support move previous.

If it's pure Access, I think you need a dynamic cursor:

Rs1.Open strSql, dbConn, adOpenDynamic

Tranman

 

[SkipVought]

Rs1.Open strSql, dbConn

uses the DEFAULT cursor which is adOpenForwardOnly.

Take PH's advise!

Skip,

http://www.TheOfficeExperts.com

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[myasin78]

Got it! adopenkeyset worked.

thanks alot guys