Hi,

I'm developing an application in VB6 that integrates with my SQL Server 7.0 Database. So far, I've got a form that allows me to read from, write to and Add new records to my recordset. I've also included two little controls that are supposed to allow me to move back and forward through my recordset, populating my textboxes as I move through the entries. The only problem is, my "Next" command button (Using MoveNext) and my "Previous" (using MovePrevious) buttons only allow me to cycle through the first two records. Is there some code I'm missing or something I'm doing wrong? Any help would be appreciated.

(Code Sample for "cmdNext")

[I]Private Sub CmdNext_Click()
Dim mysql As String
mysql = "select * from prdProduct"

xcGetRecordSet rsprod, mysql, "ED"
If rsprod.EOF Then rsprod.MoveFirst Else rsprod.MoveNext
Set DataGrid1.DataSource = rsprod
txtName.Text = rsprod!ProductName
txtDesc.Text = rsprod!ProductDescription
txtQuantity = rsprod!QuantityOnHand
lblProdNum = rsprod!ProductKey

End Sub

Thanks,
Josh