Question

__________ will display only that particular record where the record pointer is currently placed​

Answer 1

Recordset move method

Explanation:

• The current record pointer moves to the beginning of the file if you use Move to place it before the first record.
• If the Recordset has no records and the BOF property is set to True, then attempting to move backwards using this method results in an error.
• As soon as you move the current record pointer after the last record, it moves to the file's end, so be careful. Moving forward with this method fails if the Recordset has no records and the EOF property is True.
• A semantic error occurs if the BOF or EOF property is True and you plan to use the Move method without a legitimate bookmark.
• The rows option must be a positive number when using advance a forward-only Recordset object, and bookmarks aren't allowed. As a result, your only option is to proceed forward.
• If you want to make the first record in a Recordset the current record, use the MoveFirst or MoveLast method.
• Retrieving the current record's underlying data is as simple as using Move with rows equal to 0. Using this, you can ensure that the current record contains the most up-to-date data from the database's base tables.
• It will also cancel any pending Edit or AddNew requests.