Why doesn't RecordSet.MoveLast work?
.MoveLast means that you are on the Last record, therefore, EOF is false. If
you try to do a movenext when you are on the last record, then EOF is set to
> When my routine got stuck in an endless loop, I narrowed it down to this
> simple test.
> FRS.EOF always is FALSE! Shouldn't .MoveLast cause .EOF to be true?
> What am I missing?
> Here is my code:
> Private Sub listAvailFiles_Click()
> Dim DBfiles As Database
> Dim FRS As Recordset
> Set DBfiles = OpenDatabase("c:\program files\microsoft visual
> Set FRS = DBfiles.OpenRecordset("Files", dbOpenDynaset)
> Debug.Print FRS.EOF
> End Sub
> All responses will be appreciated.