See Also Example
Table object, Dynaset object, Snapshot object .
After using the MoveNext method, indicates whether the current record Not available at design time; read-only at run time. position is after the last record in a recordset.
The EOF property settings are:
True The current record position is after the last record in a recordset.
False The current record position is on or before the last record in a recordset.
Check the EOF property before using the MoveNext method to avoid moving beyond the limits of a recordset as you move from record to record. If the current record is the last record, then EOF will be True after you use MoveNext. If you use MoveNext while EOF is True, an error occurs and EOF remains True. There is no current record when EOF is True.
When you create or open a recordset containing at least one record, the first record is the current record and EOF is False. If the recordset contains no records, both BOF and EOF are True.