Chapter 8, Problem 19RQ

Explanation of Solution

Command to move the next record in a recordset in Access:

• The command used to move the next record in a recordset in Access is “MoveNext”.
• Using the “MoveNext” command, the current record position is forwarded to one record.
• When the recordset is empty, a call to “MoveNext” will throw an error.

Example:

'Loop to iterate

Do Until.rs.EOF

    'Print the customer name

    Debug...