While opening the recordset object we define different parameters and based on that we can handle the data collected by recordset object. Based on the query we apply our recordset object will fetch data for us. Recodset object maintain a pointer to this set of records and this pointer always points to one row or one record at a time. We can move to different locations in different directions by using methods associated with recordset object. We will try to understand some of the methods here.
This is a Boolean value that gets the value True if the record pointer is at the end of a set of records. This property is often used while displaying all records of the recordset object by looping through. Each time at the beginning of the loop EOF property is checked and record is displayed ( inside the loop ) if EOF is not true.
Like EOF (explained above )BOF gets TRUE value if recordset is pointing to the first record of the set of records the recordset object is having.
This moves the pointer by one step in forward direction. It will generate an error if record pointer is at the last record or the EOF property is true.
: This moves the recordset pointer by one step backward. This depends on the Cursourtype we declare at the time of opening the recodset object. We can't use MovePrevious for a forward-only cursor. MovePrevious will return error if BOF property is TRUE.
: With this we can move the pointer to beginning of the set of records.
: Goes to the last record
: Goes (or jumps) to the number of record from the current pointer position.