Example:
Private Sub nextrecord_Click()
Dim rs As Recordset
strsql = "select username from regedit "
Set rs = db.OpenRecordset(strsql)
rs.MovePrevious
txtFields.Text = rs.Fields(0).Value
End Sub

If I click nextrecord command I can get the second record. If I click it again.I can't get the third record.So how to write these code ?
Thank u!