' cycles between 1 and 3
Sub btnPrev_Click
rs2=sql1.ExecQuerySingleResult("Select COUNT(RowID) FROM table1")
' If RowID <= 0 Then ' crashes going from 1 to rs2(total row count)
If RowID <= 1 Then ' goes from 1 to 3, skips rs2(total row count)
RowID = rs2
ReadBlobPrevious ' The 2 ReadBlob subs differ only at (RowID + 1) for ReadBlobNx, and (RowID - 1) for ReadBlobPrevious
Log(" ")
Else
ReadBlobPrevious
Log(" ")
End If
RowID = RowID - 1
Log("btnPre current Row = " & RowID)
End Sub