Simple way to move in a recordset.

[sseigler]

I have a text field that displays the first field in my recordset. I want to put in command buttons to scroll back and forth to view the various fields. Below is one of the ways that I have attempted to do this.

Private Function btnNext_onclick() As Boolean

rstTechnicians.MoveNext

End Function

My rstTechnicians recordset contains one column with several rows of data.

All help is greatly appreciated,
Stephen

[Bigley]

Private Sub Command1_Click()

rstTechnicians.MoveNext
text1 = rstTechnicians(0)

End Sub

You'll probably want to check EOF in there aswell but essentially it is what you had yourself