Computer Learning Zone

Understanding BOF and EOF in Microsoft Access Recordsets

23:54

BOF and EOF are easy to memorize in Access VBA, but understanding what they mean can save you from some very confusing recordset behavior. This episode explains why EOF alone does not prove a query returned no records, especially after code has moved past the last row.

Learn how DAO recordsets track a current record, what happens when you use MoveNext or MovePrevious, and why BOF and EOF are…